topic Re: oracle data export in Operating System - HP-UX

oracle data export

raj111 — Thu, 15 Jan 2009 09:37:37 GMT

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...

Re: oracle data export

Alexander M. Ermes — Fri, 16 Jan 2009 11:11:54 GMT

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

Re: oracle data export

Steven E. Protter — Fri, 16 Jan 2009 11:22:29 GMT

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

Re: oracle data export

Vadim Loginov — Mon, 19 Jan 2009 14:08:37 GMT

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

Re: oracle data export

Yogeeraj_1 — Tue, 20 Jan 2009 11:01:49 GMT

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