Is it possible to change the tablespace which the user is imported to (during import)?
Printable View
Is it possible to change the tablespace which the user is imported to (during import)?
I would think no, but in all honesty I never tried.
You can change the user default tablespace before import, than run a schema level import. That would be cleaner, and less risky.
MH
Create the table in that tablespace and then import it with ignore =y.
oh joy, new 10g toy
impdp Scott/Scott DIRECTORY=dpump_dir1 DUMPFILE=newtbs.dmp REMAP_TABLESPACE='USERS':'NEW_USERS'
I've heard good things about the new Data Pump. Much faster! Can't wait to try it myself. But I have to wait till it's released for AIX. :(Quote:
Originally posted by pando
oh joy, new 10g toy
impdp Scott/Scott DIRECTORY=dpump_dir1 DUMPFILE=newtbs.dmp REMAP_TABLESPACE='USERS':'NEW_USERS'
1. drop all of the objects this user owns. You can 'select' the drop statements you need (script attached) in much the same way we 'select' the alter table/index statements
2. revoke UNLIMITED TABLESPACE from the user
3. alter the users default tablespace to the target tablespace
4. give the user an unlimited quota on this new tablespace and their temporary tablespace
5. IMP this users data.
During import issue the below commandQuote:
Originally posted by Markelenkov
1. drop all of the objects this user owns. You can 'select' the drop statements you need (script attached) in much the same way we 'select' the alter table/index statements
2. revoke UNLIMITED TABLESPACE from the user
3. alter the users default tablespace to the target tablespace
4. give the user an unlimited quota on this new tablespace and their temporary tablespace
5. IMP this users data.
will split the tables into different tablespaces.
alter user xx default tablespace <>;
give quota on that tablespace