Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT with an existing table
On Thu, 1 Jan 2004 19:48:19 +0100, "Vince" <vteyssier_at_nerim.net>
wrote:
>Hi,
>I want to import an already existing table in a schema but I want to keep
>both the original table unchanged and the newly imported one. What is best
>to do ? I think of making a temporary schema, import table then transfert
>data from the temporary schema to the destination schema in a newly created
>table (with different name) ?
>I'm not dba, sorry for this - maybe - stupid question.
>Thanks and happy new year
>Vincent
>
Should work, provided you use the fromuser= touser= clauses on the imp command line. Create table <old_schema>.<new_table_name> as select * from <temporary schema>.<old_table_name> to copy the data to a new table
-- Happy New Year Sybrand Bakker, Senior Oracle DBAReceived on Thu Jan 01 2004 - 13:16:07 CST