Re: Data archiving

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Wed, 06 May 1998 13:54:22 -0400
Message-ID: <3550A3CE.6F1F@ictgroup.com>

Hi,

Why not:

SPOOL <file_name>
SELECT * FROM <table_name>;
SPOOL OFF Regards

Jerry

Terence Teoh wrote:
>
> Need help from anyone who is experienced in Oracle Data Warehousing
> I need a universal scripts (that works on any database with minimal
> modification) to archive data in my databases into text files (or any other
> format) for history retention purposes. Any hints on where could find this
> sort of script or how i could start building it would be most welcomed..

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com      Opinions are mine not those of ICT Group

Received on Wed May 06 1998 - 12:54:22 CDT