Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling indexes during data import
What I did on oracle 8:
1> partition the tables. 2> drop all indexes 3> direct load 4> recreate indexes nologging (waaayyyy faster).
Steve
p.s
assuming the indexes on the data subsets (partitions)
still aren't too big...
--
Please remove nospam from my address to Reply.
Received on Mon Feb 01 1999 - 17:30:20 CST