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

Don't forget disabled logging on destination table on insert.

Reards,
Roblop

Gerd Kock wrote in message <396b6e37.8275593_at_news.btx.dtag.de>...
>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.
>>
Received on Fri Jul 14 2000 - 00:00:00 CDT