Thank Stephane and Jacques for your reply. We are running Oracle 8.1.7.4,
but will upgrade to Oracle 9.2.0.3 soon. Partitioning works for some of our
tables. Are there other methods that allow us to avoid the problem of
unique constraint.
>From: "Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: data loading
>Date: Mon, 06 Oct 2003 14:29:24 -0800
>
>If you choose to implement this method, make sure that all the tables can
>be in the exchange partition command. The exchange partition command has
>certain requirements to be able to complete the exchange (similarity of
>indexes and constraints), and the table has to be suitable for building a
>"copy" as a partitioned table.
>For example, the method would not work with this table (because of the two
>unique keys):
>create table t (a number unique, b number unique) ;
>If your database version is 8.0 there are even more restrictions on what
>kind of table you can use in an exchange partition command (IIRC any FK
>constraint will prevent you from using the table in an exchange partition.)
>
> > -----Original Message-----
> > Stephane Paquette
> >
> > You can use the partitionning option.
> >
> > Load into a 1 partitionned table then do a partition exchange with the
> > target table.
> >
> > It allows you to have the current data live while loading into the
> > partitionned table.
> > Once the load is loaded just exchange the partition with the
> > table, it is
> > fast as it is just an update in the data dictionnary. No data
> > is physically
> > moved.
> >
> > -----Original Message-----
> > Nancy Hu
> >
> > We have an Oracle database that is a kind of data warehouse.
> > We load data
> > from mainframe into the database every day. The following
> > are the steps how
> > we load data currently:
> >
> > 1. get the data file from Datacom
> > 2. ftp the data file from mainframe to the Sun machine where
> > the Oracle
> > database resides
> > 3. truncate all tables in Oracle database
> > 4. load the data into Oracle with SQL LOADER
> >
> > Most tables in the Oracle database don't have primary key.
> > Tables are not
> > available during the loading that gives us problem for our 24x7
> > availability. Therefore, we would like to change our loading
> > method. Any
> > ideas would be highly appreciated.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jacques Kilchoer
> INET: Jacques.Kilchoer_at_quest.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Instant message in style with MSN Messenger 6.0. Download it now FREE!
http://msnmessenger-download.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nancy Hu
INET: nancyhu68_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 08 2003 - 11:24:25 CDT
