Cannot extract a too large text file??

Hi guys

I would like to extract a table that contain a LOTS of values to a text file, but it says that the file cannot be extracted cos it is too large.

So my question is whether there is a way to divide the large table into...say 4 parts and then select each part into 4 different text file.

Example:
Let say that a table have 1,000,000 rows
Is there a way to select the first 250,000 rows into the 1st text file and then in the 2nd text file select the next 250,000 rows....and so on

Or do anyone have any better idea to extract a very large text file?

Thanks.

Hi,

you can try and do this from utl_file (i'm not sure there is a limit to the size of the file other than what the system impose).

Galit.

The following is not a permanent but a temporary solution.

for example you want to use the same approach on EMP table.

create a view with rownum column as follows

CREATE OR REPLACE VIEW view_emp
AS SELECT empno,ename,sal,mgr,job,hiredate,deptno,rownum row_count
FROM emp
/

now use this view to fetch the record by limiting number of rows.

SELECT * FROM emp
WHERE row_count BETWEEN 1 AND 10
/

SELECT * FROM emp
WHERE row_count BETWEEN 10 AND 100
/

Sorry, use view in SELECT statement

SELECT * FROM view_emp
WHERE row_count BETWEEN 1 AND 100
/