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

Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling indexes during data import

Re: Disabling indexes during data import

From: BTINet News <jeffh_at_btitelecom.net>
Date: Thu, 28 Jan 1999 20:38:37 -0500
Message-ID: <78r33m$he9$1@defiant.btitelecom.net> 





You could approach this problem in ways:
1. Drop all the existing tables and import the production data
2. Drop all the indexes and then run the import



In either case, you probably don't want the indexes on your tables when you
run the import.  The indexes and triggers will get re-built _after_ the data
is imported.



J



Received on Thu Jan 28 1999 - 19:38:37 CST












Original text of this message













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