RE: historical data

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 22 May 2001 09:58:33 -0700
Message-ID: <F001.0030AC0C.20010522071314@fatcity.com>

Take a look at Thomas's Kytes utility "Data Unloadder" on his website.

Also look at Oriole's PDQ OUT. Both products will avoid the need to recreate the wheel.
Also, toad can do this.

-----Original Message-----
Sent: Monday, May 21, 2001 6:17 PM
To: Multiple recipients of list ORACLE-L

We have to role off partitions of data every week and I am writing a script to
write the data to comma separated files using utl_file. What I was wondering is
does anyone have an alternative that is better? I thought about using export but
thought it wouldn't be fun trying to import an export file into the latest version
of Oracle 10 years down the road.

Thanks, Dave
--

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

Author: David Turner
INET: turner_at_tellme.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).
--

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

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

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