Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reducing scale/precision with exp/imp?
On Wed, Feb 08, 2006 at 01:19:56PM +0000, David Sharples wrote:
> you could create a new table, insert the data, truncate old one, modify the
Assuming you can have some downtime for the production app, otherwise you have to devise some way to account for the deltas between the time when you copy the table and when you go down for the exp/imp. Is there a built-in ora diff like command to handle this problem? I've done this with scripts based on timestamps or sequence numbers in the tables.
-- Think of a "happy place" where you go when want to feel better. - Millsap, Holt -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 08 2006 - 07:45:47 CST
![]() |
![]() |