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 ;
---
I hope this helps:
--
drop table test_bal ;
--
-- create a sample table
--
create table test_bal( my_pk number);
--
-- Insert sample data
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
ROTECTED]>
cc:
Subject: Breaking down values in a large table
Listers,
I have a table of 125M rows (not partitioned) which I am exporting. I want
to break the export into 4 dmp files using the query command on the pk
column.
I am looking at how the best way of finding the value
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 the
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 log_n
MAIL PROTECTED]>
Subject: Breaking down values in a large table
Date: Tue, 11 Feb 2003 06:19:09 -0800
Listers,
I have a table of 125M rows (not partitioned) which I am exporting. I
want to break the export into 4 dmp files using the query command on the
pk column.
I am looking at how the best way o
down values in a large
table
Listers,
I have a table of 125M rows (not
partitioned) which I am exporting. I want to break the export into 4 dmp files using the query command on the pk column.
I am looking at how the best way
of finding the values of the PK (number) which are at
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11,
2003 9:19 AMTo: Multiple recipients of list
ORACLE-LSubject: Breaking down values in a large
table
Listers,
I have a table of 125M rows (not
partitioned) which I am exporting. I want to break the export into 4 dmp files using the
Listers,
I have a table of 125M rows (not partitioned) which I am
exporting. I want to break the export into 4 dmp
files using the query command on the pk column.
I am looking at how the best way of finding the values of
the PK (number) which are at 25%, 50% and 75% ish for
the table s
10 matches
Mail list logo