Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Direct load into Partitioned table with Global Index
Anybody knows how to using sql*load directly load data into partitioned table
with global index defined on it. We had a situation that we have a table
holding about 12 month of data (about 120GB). For every month, we need to
delete earlist month data from the table, and add latest month data into the
table. We had global index defined on the table, off course. We thought we
could partition the table by month, and every month just drop the partition
with the earlist month from the table, and add latest month partition to the
table, then load data using direct load. However since there are global
indexes defined on the table, Oracle won't let you using direct load. We can
not simplly drop indexes, and recreate them after loading since that would
take days to do that (it may even simplly blow out all my resources). We may
be able using view partition instead of table partition, however Oracle
sugguest to use table partition instead view partition. It just surprise to
me that Oracle doesn't support direct load on partition table with global
index on it since this is very common in data warhouse application (I can not
image this type size of table without global index). Anybody have any
experience with those issues, any way work around? Any sugguestion are
welcome!
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 30 1998 - 15:26:34 CST