import to different table name ?

[slothfur]

is there a way to import a table to a different table name ?

[Mr.Hanky]

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

[slothfur]

no, i was hoping that there's a command out there that would let you specify something like
FROM table TO table...

[slimdave]

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.

[prakashs43]

can i know if there is any specific reason for not using

insert into table as select ....
or
renaming a table after insert .