-
import to different table name ?
is there a way to import a table to a different table name ?
-
Not that I know of, you can do a..
SQL>insert into as select from
Or just re-name the table after import, no?
MH
I remember when this place was cool.
-
no, i was hoping that there's a command out there that would let you specify something like
FROM table TO table...
-
If you exported a table OLD_TABLE and wanted to import it as NEW_TABLE, then you might try pre-creating NEW_TABLE, then putting a view on it as ...
CREATE VIEW OLD_TABLE AS SELECT * FROM NEW_TABLE
... and running a conventional path import, making sure to set it to ignore errors on import.
This sort of thing can also work for importing into a table having a different column list.
-
can i know if there is any specific reason for not using
insert into table as select ....
or
renaming a table after insert .
siva prakash
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
|