Import table with a different name from an export?
136406Oct 16 2007 — edited Oct 16 2007Hello everyone,
I wish to make an import of just one table (from an export) of just one table but I wish to give the imported table a new name. For example,
imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept
The table "dept" was included in my export - it still exists in the database - I just want to import it as "dept_new"....To make a comparison.
Is this possible in the command line?