Hi
How can i import a table from an export file with different name within same schema.
e.g i have a table a1 in user1 schema and have exported this table only.
now i want to import this table as a2 with same schema user1
Printable View
Hi
How can i import a table from an export file with different name within same schema.
e.g i have a table a1 in user1 schema and have exported this table only.
now i want to import this table as a2 with same schema user1
Is it what you want?Code:create table a2 as select * from a1;
I know this. but can i do same from imp utility.Quote:
Originally Posted by SANJAY_G
no, you cant rename tables
export your table first, rename table to table_old, import table back, rename imported table to table_new, rename table_old to table.
Wondering why someone would want to do this. :confused:Quote:
Originally Posted by BV1963
and not 'create table as select'.