|
If the table name is the same, then this is quite
easy. The only trick is to tell the IMP utility to
ignore the fact that the table already exists.
Otherwise, the IMP utility will die with an error. To
import, and change the owner, your import parameters
will look something like:
imp userid=system file=export.dmp
fromuser=original_owner touser=new_owner
tables=the_table_name ignore=y
The IMP utility cannot change the table name in the
process. If that is a requirement, then you'll have to
import the data with the existing table name and use
SQL statements to move the data to the correct table.
For More Information
|
