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

with exp/imp you may put the table into a different schema (fromuser, touser), but you cannot give the table a different name. I think you have to create table <new_name> as select ... where...

use where-clause if you don't need all the data. if you need the table with same name and without any data and want the old data be stored in a table with different name, rename table and create original table again.

Hope that helps.
Gerd Kock

www.BITS-on-the.net
On Tue, 11 Jul 2000 18:41:15 GMT, andreyNSPAM_at_bookexchange.net (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

Gerd Kock
Baltic IT Service GmbH
Gerd.Kock_at_BITS-on-the.net Received on Tue Jul 11 2000 - 00:00:00 CDT