]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the database.
This is the requirement
We define a retention period for all the data in the system.
When the retention period is reached, the data should be deleted
Another poor man's solution would be to unload the tables into flat files and attach
to them as needed using Oracle's external table feature from 9i. That solution
should hold for quite a while into the future since the external table function is
very
much like SQL*Loader, which is so
to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the
database.
This is the requirement
We define a retention period for all
:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the
database.
This is the requirement
We define a retention period for all the data in the system.
When the retention period is reached, the data should be deleted, but
then at a later
Burnt mud? Isn't that all scotch?
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Steve McClure [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 4:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Purging Strategy
Sherry
Title: RE: Data Purging Strategy
And finding something to play that CD in 50 years, much less understand the data format, will be like finding something to play an old 78 now.
78. How's that for showing my age! I even had a 16 once. And a 4-track (pre 8-track).
Jerry Whittle
ACIFICS DBA
Hair of the dog! I wonder if that would help my sorry butt.
Might have to leave for the airport early and sit at the bar until the stupor
clears. Hope I don't miss my plane.
D
[EMAIL PROTECTED] wrote:
Burnt mud? Isn't that all scotch?
--
Please see the official ORACLE-L FAQ:
recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the
database.
This is the requirement
We define a retention period for all the data in the system. When
: RE: Data Purging Strategy
Sherry Finish? I thought you liked scotch that tasted like burnt mud?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
That reminds me:
Mark, your annual stipend is due
water constantly dripping on stone, will wear away the stone. And an
earthquake, with debris falling on that stone could shatter it.
I don't think even that will work
--- MacGregor, Ian A. [EMAIL PROTECTED] wrote:
I went to one meeting where someone from another DOE lab said they
needed to
-L
[EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the
database.
This is the requirement
We define a retention period for all the data in the system. When the
retention period
-Original Message-
I went to one meeting where someone from another DOE lab said
they needed to store some data on media which would last
10,000 years. I suggested chisels and stone tablets :)
That gold platter that NASA sent out into space: How long is it supposed to
last?
Stephen Lee wrote:
-Original Message-
I went to one meeting where someone from another DOE lab said
they needed to store some data on media which would last
10,000 years. I suggested chisels and stone tablets :)
That gold platter that NASA sent out into space: How long is it
Hi Tim
We just signed a contract for external storage system from EMC and the
configuration is going to be:
Regular servers - connect as Nas
Database servers - connect as San.
If I remember correctly Nas use SCSI connections while San use fiber.
Yechiel Adar
Mehish
- Original Message -
by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd
party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list
, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the database.
This is the requirement
We define a retention period for all the data in the system.
When the retention
it to offline tape with the
knowledge that you may never see that data again.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 01:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Data Purging
by: [EMAIL PROTECTED]
11/06/2002 01:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the database
it to offline tape with the
knowledge that you may never see that data again.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 01:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Data Purging
Dear List,
I need some inputs from you all regarding purging data from the database.
This is the requirement
We define a retention period for all the data in the system.
When the retention period is reached, the data should be deleted, but then at a later time, some user might request for
Prem,
I
would re-visit the requirement. Why do you feel the need to delete the
data from the database? What is the purpose for this type of
requirement? It would be far easier to modify the requirement than to do
what you are thinking of doing.
Adding
columns to database tables
ed storage, and then finally reside in
archive media file-systems such as tape or magneto-optical based HSM
file-systems.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 06, 2002 2:13
AM
Subject: Data Purging Strat
the data back because of software
compatibility issues.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Data Purging Strategy
here's some
gotchas involved but some variation on that theme might
work.
Jim
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Data Purging Strategy
Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
- If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
- PrincetonSoftech has a product
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L
Prem - You are receiving some excellent advice
Hey, thanks for mentioning that, I'll have to mind my manners. I really
don't have a connection to that vendor, just attended a demo.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 06, 2002 9:56 AM
To: Multiple recipients of
PROTECTED]
11/06/2002 01:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Data Purging Strategy
Dear List,
I need some inputs from you all regarding purging data from the database
LOL! Thanks John! ;)
As a matter of fact.. ;P
I do actually know of another tool that does just this, it's called
Checkmate from a company called BitByBit http://www.bitbybit.co.uk (which I
have just checked and it now seems they have been acquired by OuterBay!)..
We actually used to promote
]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd
party
products.
I am sure he bought the franchise from Jared :)
John
, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only
, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 06, 2002 7:18
AM
Subject: RE: Data Purging Strategy
Tim,
my
problem with moving data to tape is as follows:
Your
one strategy involved moving read-only tablespaces to tape. what if you
and
hoping you can use it later.
Jared
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 03:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Data Purging Strategy
Agreed
...
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 4:26 PM
Subject: Re: Data Purging Strategy
Tim,
I missed the part earlier where you mentioned HSM. Though somewhat
familiar with it, I've never used
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed
to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original
40 matches
Mail list logo
