- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle data export
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2009 01:37 AM
тАО01-15-2009 01:37 AM
oracle data export
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2009 03:11 AM
тАО01-16-2009 03:11 AM
Re: oracle data export
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2009 03:22 AM
тАО01-16-2009 03:22 AM
Re: oracle data export
The toad oracle toolset also provides the ability to write sql statements and export them to a file with any delimiter you choose.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2009 06:08 AM
тАО01-19-2009 06:08 AM
Re: oracle data export
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2009 03:01 AM
тАО01-20-2009 03:01 AM
Re: oracle data export
Write the script that would run using sqlplus as follows:
e.g.
spool file1.csv
set escape '\'
select field1||'\|'||field2||'\|'||field3
from tab1
where
hope this helps!
kind regards
yogeeraj