Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How does one exp/imp of table into a different table in the same schema?
export table, rename it, import it, so that it will be created again with the old name (while nobody uses the database).
Yours Sigrid
seh_at_carus.de
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 Wed Jul 12 2000 - 00:00:00 CDT