About archiving

From: Oak, Sameer <soak_at_ziptone.com>
Date: Thu, 22 Feb 2001 08:04:44 -0800
Message-ID: <F001.002BAA77.20010222075619@fatcity.com>

Hello Gurus

I would like to know the industry standards for archiving the data on say monthly basis considering that it may have to recovered any time later .

What is the best way to do it???

I come up with one idea.

The steps
1. Create temporary tables with the logical set of database(tables) to be archived.
2. Export them
3. Import only data when required.

My manager does not like the idea & he claims that there must be some industry standard way for doing it. May be a third party tool.

Thanks

sameer
--

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

Author: Oak, Sameer
INET: soak_at_ziptone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Thu Feb 22 2001 - 10:04:44 CST