Import with Diff Table name [message #6543] |
Wed, 23 April 2003 23:55 |
Ramki
Messages: 26 Registered: September 2002
|
Junior Member |
|
|
Hi all,
We are doing Export table data from lower version of our Application and this table is to be Imported with different name in newer version.
I can't rename this table after import since Table is already created by application installation.
So I want change the table name while importing itself.
Is it possible to do ? or any other trick?!
|
|
|
Re: Import with Diff Table name [message #6545 is a reply to message #6543] |
Thu, 24 April 2003 04:57 |
Keith
Messages: 88 Registered: March 2000
|
Member |
|
|
Do the import with the old name, then do:
create table new_table_name as select * from old_table_name;
drop old_table_name;
I don't believe you can change table names as part of an import.
|
|
|