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?
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