Skip to Main Content

Oracle Database Discussions

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!

Export Data to a Text file

632529Aug 18 2009 — edited Sep 2 2009
Is there an oracle utility that one can use to automate export of oracle table data into a text file(*.txt) in a format readable by other window applications. I have seen examples using sql plus but I need some thing that can be scheduled to run late at night or early in the morning. I dont want to manually create the file everyday. If there is no utility is there a way to run sql plus in a windows batch file to create such an output.
Thanks
Bunmiog
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2009
Added on Aug 18 2009
11 comments
68,181 views