Re: need some advice(you partition experts out there, this one is for you).
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Apr 2004 18:10:01 +0100
It looks like you need to:
Create working table as select old data excluding
new number, year and qtr from old partition
Insert append new data into working table.
Index working table
Exchange.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http://www.index.is/oracleday.php
June 2004 UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar
----- Original Message -----
From: <jtesta@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, April 23, 2004 6:00 PM
Subject: need some advice(you partition experts out there, this one is for
you).
Ok here is the scenario:
we will have a table partitioned by list on a number, so far so good.
also as part of that table is a processing yr and qtr.
we will be doing the ETL thing on number, yr, qtr at a time.
here is our process:
get data, do the etl at number, yr and qtr at a time. we want to load
into a temp table, build the bitmap index(es) on the temp table and then
do a partition exchange, all doable up to this point.
we have data for older years already in the number (remember its list
partitioned), we need the users to have access to the older data while
we're processing and then want to do an exchange into the fact partition,
but exchange is TRULY exchange, how can we basically append the new data
into the exchange but w/o the overhead of the bitmap indexes killing us.
We're trying to not drop the bitmaps as there will be 12 FK to dimensions.
We used to do range partitioning but this process to do the ETL is totally
dynamic and builds partitions on the fly if need be, List partitioning is
alot easier to add a partition then to do the split partition thing if the
number falls in the middle.
any thoughts on this one would be greatly appreciated.
thanks, joe
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
