Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reducing scale/precision with exp/imp?

Re: Reducing scale/precision with exp/imp?

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Wed, 8 Feb 2006 08:45:47 -0500
Message-ID: <20060208134547.GC3960@cns.vt.edu>


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
Received on Wed Feb 08 2006 - 07:45:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US