Sponsored Links
EXP IMP to a different tablespace
EXP/IMP to a different tablespace
if the tablespace of the object does not exist,
import users default table space will be used.
Personally, I would:
1. export USER-A
2. imp indexfile=abc.sql
3. edit abc.sql
3a. change references from old TS to new TS
3b. uncomment create table statements
4. run abc.sql to pre-create objects from sqlplus as USER-B
5. imp fromuser=user-a touser=user-b ignore=y
Page 1
|
| 
