Oracle-L: RE: data loading

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Mon, 06 Oct 2003 13:39:23 -0800
Message-ID: <F001.005D2302.20031006133923@fatcity.com>

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.

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187 stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

-----Original Message-----
Nancy Hu
Sent: Monday, October 06, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L

Hi All,

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:

get the data file from Datacom
ftp the data file from mainframe to the Sun machine where the Oracle database resides
truncate all tables in Oracle database
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.

Nancy

Instant message with integrated webcam using MSN Messenger 6.0. Try 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

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 Mon Oct 06 2003 - 16:39:23 CDT