Re: How does one exp/imp of table into a different table in the same schema?

Hello,

You will only have a problem if you want to export/import the table into the same
schema. If this is not the case, you may want to use TO_USER to import into
another schema and then create a synonym for the new table.

If you still want to import into the same schema, you can (carefully) edit an export file
by changing all tablename occurences there (mommy would not advise you to do it in production).

However I dont see reasons why you cannot do CREATE as SELECT. Actually, since the table is so big you may encounter problems with imp/exp if the export file
exceeds 2G in size. With 8i you should be ok.

Hope this helps
Karen

NetComrade wrote:

> I am sure it could be something simple, but I just can't figure it
> out. I need to keep the old table for now b/c it's used in production.
> Create table as select also is not a great idea, since the table is
> 50000000 records.
>
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Tue Jul 11 2000 - 00:00:00 CDT