Thanks Dennis for the encouragement.
I really try not to take it out on them. I work for the financial security of my family but I also don't want it to impact (or at least as little as possible) my relationship with my kids. I feel as their mother I need to be as patient and kind as possible even with little sleep. Later I beat my head alone in my office. Hehe.
-----Original Message-----
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 31, 2003 10:48 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: archiving data
Paula - Sorry to hear you are having problems. Since your posting time was
last night, hope you fixed the problem in time to have a weekend with your
kids. I get hit by the same thing now and then. You are right that you want
to see your family, but when you are tired and grumpy they may not enjoy
you. Better spend the time while the tape is loading planning a comp day to
spend some well-rested time with them.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, May 30, 2003 7:45 PM
To: Multiple recipients of list ORACLE-L
I/O failure this week. Productional system restore/verified and backed up -
fully operational once I/O subsystem rebuilt in 2.5 hours - required full
restore because key datafiles corrupted - system, redos, control.....
Waiting for I/O took longest didn't see kids all night.
Was supposed to take off today.
Working as technical architect on SQL Server Vital Stats. COTS, project
planning, setting up processes for releases and standard forms, data
migration/cleansing, QA plan.
Another "test" database recovery tonight.
I miss my little boys.
I want to escape.
I want to eat an entire French Silk Pie
-----Original Message-----
Sent: Friday, May 30, 2003 7:55 PM
To: Multiple recipients of list ORACLE-L
how do you define "older than 12 months"??
are you using enterprise edition and is it feasible to use
partitioning?, if you partition on the field that defines "older than
12 months", its easy enough to drop a partition(or exchange a partition
with a non-partitioned table, export that and drop it.
joe
Sai Selvaganesan wrote:
>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
>
>
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
