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

Other related posts: