sqlldr remap_schema
(edit: I meant EXPDP/IMPDP not SQLLDR )
I use SQLLDR to copy table structures, packages and data from one schema to another one, both schemas on the same Oracle server. Here is my commands:
(My serser is RHEL 5.8 with Oracle 11gR2.)
# expdp system/password schemas=its directory=dmpdir dumpfile=its_schema.dmp version=10.2
and
# impdp system/password remap_schema=its:its_training directory=dmpdir dumpfile=its_schema.dmp version=10.2
I just found out that when I drop the original schema, which is its in the above commands, then all the tables and data in the other schema, which is its_training, are dropped/deleted.
I use SQLLDR to copy table structures, packages and data from one schema to another one, both schemas on the same Oracle server. Here is my commands:
(My serser is RHEL 5.8 with Oracle 11gR2.)
# expdp system/password schemas=its directory=dmpdir dumpfile=its_schema.dmp version=10.2
and
# impdp system/password remap_schema=its:its_training directory=dmpdir dumpfile=its_schema.dmp version=10.2
I just found out that when I drop the original schema, which is its in the above commands, then all the tables and data in the other schema, which is its_training, are dropped/deleted.
0