-
import a table's data within same schema to different table
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
~KD.DBA~
-
Code:
create table a2 as select * from a1;
Is it what you want?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Originally Posted by SANJAY_G
Code:
create table a2 as select * from a1;
Is it what you want?
I know this. but can i do same from imp utility.
~KD.DBA~
-
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.
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
Originally Posted by BV1963
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.
and not 'create table as select'.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|