oracle data export

[raj111]

hi

i want to export data from oracle database to "|" separated csv files, and file size should not be exceeded then 1GB. I have a lot of data to export.
please suggest me how to do that...

[Alexander M. Ermes]

Hi there.
I think, you will have to do it by sqlplus.
select field1 || ';' || field2||';'||

or by a script with dbms_output to limit your filesize.

make your lines large enough ( set lines 5000 ) and your file without braks ( set pages 0).
Rgds
Alexander M. Ermes

[Steven E. Protter]

Shalom,

The toad oracle toolset also provides the ability to write sql statements and export them to a file with any delimiter you choose.

SEP

[Vadim Loginov]

Hi,

Yes, you can use SQL*Plus, here is what you need to do:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-sql-l/how-to-export-the-content-of-a-table-into-csv-and-then-xls-1663934

Donâ t forget to enable SERVEROUTPUT parameter in SQL*Plus and set it to 1000000 (max value in bytes for Oracle 10gR1 and before)

Bear in mind that PAGESIZE parameter has maximum value 50000.

Regards
Vadim

[Yogeeraj_1]

hi,

Write the script that would run using sqlplus as follows:

e.g.
spool file1.csv
set escape '\'
select field1||'\|'||field2||'\|'||field3
from tab1
where

should be such that the size of file that would be generated does not exceed the 1GB specified. NB. You would have to do some tests first.

hope this helps!
kind regards
yogeeraj