Home » RDBMS Server » Server Utilities » EXPORT IMPORT
EXPORT IMPORT [message #74659] Mon, 31 January 2005 20:15 Go to next message
Era Agarwal
Messages: 1
Registered: January 2005
Junior Member
Hi All,

I have a few tables and I need to export data from some columns from each table in a single text file. Is it possible to create a text file and then export data in it through oracle commands.

Your answres would be highly appreciated.

Thanks and Regards
Era

Report message to a moderator

Re: EXPORT IMPORT [message #74663 is a reply to message #74659] Tue, 01 February 2005 03:27 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In this case,
EXPORT would not be right terminology.
It means differnt w.r.to Oracle.
You just spool the data using simple sql commands.
For More complex operations, use utl_file builtin package to write to an OS file.
For spooling please refer here
http://www.orafaq.com/forum/t/7188/0/

For UTL_FILE please refer here
http://www.psoug.org/reference/utl_file.html

and Ofcourse, GOOGLE and oracle documentation would help you better

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: allowed errors sql loader
Next Topic: oracle services could not get started
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:46:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.