Re: Reducing scale/precision with exp/imp?
- From: Ray Stell <stellr@xxxxxxxxxx>
- To: David Sharples <davidsharples@xxxxxxxxx>
- Date: Wed, 8 Feb 2006 08:45:47 -0500
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-l