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 DBA