Change tablespace during import

[Blu]

Is it possible to change the tablespace which the user is imported to (during import)?

[Mr.Hanky]

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

[Rohit]

Create the table in that tablespace and then import it with ignore =y.

[pando]

oh joy, new 10g toy

impdp Scott/Scott DIRECTORY=dpump_dir1 DUMPFILE=newtbs.dmp REMAP_TABLESPACE='USERS':'NEW_USERS'

[jodie]

Originally posted by pando
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. :(

[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.

[engiri]

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.

During import issue the below command
will split the tables into different tablespaces.

alter user xx default tablespace <>;
give quota on that tablespace