Oracle-L: archiving data

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Fri, 30 May 2003 15:04:41 -0800
Message-ID: <F001.005A754F.20030530150441@fatcity.com>

hi there is this project that is going on for archiving old data from oltp system that is older than 12 months and then purging them in the main db.

the tables that are to be archived are with long rows. they cannot be converted to lobs since this is a third party application. here is where the problem lies. oracle support when contacted says either mv to lobs to make this move easier or use oci ..blah.blah.. to get this working if you want to remain in longs.

there are some options i have though about: 1. export /import ..but should make this highly automated since the main db and archival db will be on different hosts, this will not be monitored and import has to go thru w/o issues etc.
2. create snapshot - but they dont work with long..hence not an option.
3. getting sqlldr to work but i think it has that 32k column size limitation.

so can you please suggest me whetehr there is something else i can do or option 1 is the best given the environment. the oracle is 8.1.7.2 on sun 2.8.

thanks
sai
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sai Selvaganesan
INET: ssaisundar_at_sbcglobal.net

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 Fri May 30 2003 - 18:04:41 CDT