Re: Oracle export/import question.

From: James Brooks <brooksj_at_cpva.saic.com>
Date: 27 Jan 92 18:20:02 GMT
Message-ID: <8735.2983dcd2_at_cpva.saic.com>


In article <1992Jan24.234345.28472_at_msb.com>, dave_at_msb.com (Dave Lockwood) writes:
> Article-I.D.: msb.1992Jan24.234345.28472
> References: <1992Jan20.230326.5511_at_unixg.ubc.ca> <bartho.5_at_cc.und.ac.za>
> Organization: Meetpoint Station BBS
> Lines: 15
> Xref: network.ucsd.edu comp.databases:1032 comp.databases.oracle:86
>
> When faced with a similar situation requiring archiving of records (with
> rows in a dozen tables) as they expired, I wrote an oraperl program to write
> the data to a set of flat files with fixed length records, deleting the rows
> from the database as it ran. Restoration is just a matter of running the
> flat file through a filter to select records, and loading via SQL*Loader,
> or by another oraperl program.
>
> Without oraperl, I'd be up to my eyebrows in Pro*C by now...YECH!
>
> Cheers!
> --
> "Well, it's rather brutal here. We're | dave_at_msb.com (Dave Lockwood)
> advising all our clients to put every- | UUCP: ...!uupsi!mpoint!dave
> thing they've got into canned food and | Sysop of Meetpoint Station BBS
> shotguns." - Brain Gremlin (Gremlins II) | cat flames | mail santa_at_north.pole

I am new to this newsgroup. Could you provide me with followup info on oraperl ??

Jim Brooks Received on Mon Jan 27 1992 - 19:20:02 CET

Original text of this message