RE: Breaking down values in a large table

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 in the FILE parameter.  

Looks like what you want to do, right?  

Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, February 11, 2003 9:19 AM To: Multiple recipients of list ORACLE-L

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 so that I can get 4 evenly sized exports  

My query line in the parameter file will be along the lines of where

1)       log_no < xx
2)       log_no >= xx and < yy
3)       log_no >= yy and < zz
4)       log_no >= zz
 

I am thinking of a sql something like the following  

Select /*+ index ffs(table_name index_name) */ Log_no , floor(log_no / 4), count(*)
>From table_name group by floor(log_no / 4), log_no
 

Version is 8.1.7.1  

Can anybody help please  

Thanks  

John    

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).