Database Software

1 error has occurred

Your session has timed out.

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.

Howto export Table into tab delimited text file

Kodiak_SeattleDec 8 2010 — edited Mar 7 2012

I am an end-user, normally I connected to the 10G database 10.2.0 using TOAD, but I do have access to use SQL*Plus, and I know basics about that, how to login and stuff like that.

I need to export the contents of a Table from my schema to a Tab-delimited text file (onto my Windows XP machine), I don't have command line access to the Oracle server where
the database run on.

How do I do this, I tried to learn how to use (exp), but that seems to require access to the command line [which I don't have], and then it recommended to use data pump, but I don't know how this all works.

The table had 4.7+ million records in it and using the Toad "Save database as..." takes way too long.

Please help!

Database Software

Howto export Table into tab delimited text file

Comments

Post Details