Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Large export of pipe-delimited data

Paul Knowles3 days ago

I am trying to export a large (about 10M) data set from Oracle using SQL developer (unfortunately I don't have SQLCLI or SQL Plus available). Is there an efficient way to do this that won't type up SQL developer? Last time it took about 5 or 6 hours. With TOAD (unfortunately no longer available), it took about 15 minutes. I would rather not type up SQL developer for hours when this runs. Any suggestions on a good way to do this? Thank you.

Comments
Post Details
Added 3 days ago
6 comments
50 views