Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How does one exp/imp of table into a different table in the same schema?

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

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/07/12
Message-ID: <010d9b92.f083fb64@usw-ex0105-037.remarq.com>#1/1

It would be a nice feature. I have to copy a huge table each week in the same schema. Both tables already exist F5540121 and F41021. I trunc F5541021 and then do an insert from F41021. The amount of RBS I'm using is getting bigger and bigger as the F41021 grows. I would love to use imp/exp to export the data and then import it into the F5541021 but no dice and I can not do any of the drops or renames because they are both production tables that are registered with the ERP package.

I assume the SQL Plus Copy command is most likely my next option .

-Ethan

http://www.freetechnicaltraining.com/article_10.htm http://www.gnumetrics.com


Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US