Thanks Waleed, that is exactly what I wanted.
And thanks to all the others who responded
John
-Original Message-
Sent: 11 February 2003 22:54
To: Multiple recipients of list ORACLE-L
I hope this helps:
--
drop table test_bal ;
John,
Look
at the FILESIZE parm of export.
Lisa Koivu OracleMonkey
Administrator Fairfield Resorts,
Inc. 5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459
-Original Message-From: John Hallas
John,
Have
you looked at using the FILE and FILESIZE params that are provided via the
Export utility?
According to the docs, you can provide multiple FILE
names, and specify a FILESIZE. Once Export has created a file that is
FILESIZE in size, it creates the next export file you designated
John,
Why bother with the query; why don't you use the FILESIZE parameter of the
export to break down the export files into manageable chunks?
Arup
From: John Hallas [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Breaking
Hi John,
the FILESIZE parameter would certainly work but if you don't know how big
your export file will be then it won't help you to split it accurately into
4.
This query should get you the 25%, 50% and 75% marks. The 100% is easy.
select * from
(select rownum rnum,a.*
from (select
Tom, Lisa, Stephane
I did consider that but I was originally exporting using direct export
and I could get the whole table out in 4 hours (compressed via a pipe).
However the import takes 24 hours.
I was looking at using a normal (via the buffer ) export with a query in
so that I could import
John,
use the 'volsize' parameter.
Look at 'exp help=y'
Jared
John Hallas [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Breaking
Er, I mean, 'filesize'.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/11/2003 10:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Breaking down values in a large table
John,
use
I hope this helps:
--
drop table test_bal ;
--
-- create a sample table
--
create table test_bal( my_pk number);
--
-- Insert sample data
