Chris Spence was kind enough to mention PDQout in his response
to this question and the debate since then seems to have revolved
around whether exp/imp will still be around to reload archive data.
There can be no debate with PDQout however. It creates flat files
which can be reloaded with
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
Chris,
I've been exporting data in a similar way as you since V5. The 8i version
of import still reads them without trouble.
Dick Goulet
Reply Separator
Author: Christopher Spence [EMAIL PROTECTED]
Date: 5/22/2001 7:13 AM
Take a look at
I am not sure what you are saying here, but ok sure.
-Original Message-
Sent: Tuesday, May 22, 2001 1:31 PM
To: Christopher Spence; Multiple recipients of list ORACLE-L
Chris,
I've been exporting data in a similar way as you since V5. The 8i
version
of import still reads them
Chris,
Humm, did not think that was clear, but!! We started using export to
extract data from our operational data store back in 92 with Oracle Version 5 to
tape. These files, copied now to CD's are still usable with Oracle 8i. That's
10 years and no problems. If I can depend on
Well when you advertise that it can take 7 business days to restore the
data fast is not a consideration.
Dick Goulet
-- Reply Separator --
Author: Christopher Spence [EMAIL PROTECTED]
Date: 5/22/01 3:09 PM
Oh, yes agreed 110%.
But on another note,
I would hate to have to say it would take 7 days to do a restore.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/22/01 10:15 PM
Well when you advertise that it can take 7 business days to restore the
data fast is not a consideration.
Dick Goulet
recipients of list ORACLE-L
Subject: historical data
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
My first recommendation would be to do this with Perl and DBI.
Fairly simple that way.
If not, try using SQL generating SQL to spool the data out.
Check out dump.sql at www.cybcon.com/~jkstill/util, and modify
for your needs.
UTL_FILE will probably not work for this due to buffer
Information Services
http://www.superpages.com
-Original Message-
From: David Turner [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 5:17 PM
To: Multiple recipients of list ORACLE-L
Subject:historical data
We have to role off partitions of data every
Thanks, Dave
On Mon, May 21, 2001 at 08:05:23PM -0700, Jared Still wrote:
My first recommendation would be to do this with Perl and DBI.
Fairly simple that way.
If not, try using SQL generating SQL to spool the data out.
Check out dump.sql at www.cybcon.com/~jkstill/util, and modify
http://www.superpages.com
-Original Message-
From: David Turner [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 9:59 PM
To: Deshpande, Kirti
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: historical data
What did you use as a delimiter, and are their any limits
12 matches
Mail list logo