Copy Table to a new database
I have a 1 gig+ tables that I need to clean of old data and move to an archive database. It is a production database so I can't simply just copy it wholesale, it locks everyone else trying to hit it. Is there a way I can copy with a select statement so I can do it 1000 or 10000 rows at a time?
ie (UPDATE dbArchive.tblInvoice (SELECT * from dbProduction.tblInvoice where ID > 1600000)
Thanks
-Chris
Subject
Written By
Posted
Copy Table to a new database
August 27, 2004 08:53AM
September 02, 2004 12:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.