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?
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 ....
renaming a table after insert .
Click Here to Expand Forum to Full Width