OraFAQ Forum: Server Utilities » Writing data from oracle tables into ascii files...

Home » RDBMS Server » Server Utilities » Writing data from oracle tables into ascii files...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Writing data from oracle tables into ascii files... [message #368063]

Sat, 12 February 2000 05:51

Umesh Sharma
Messages: 14
Registered: February 2000

Junior Member

I want to take the data from oracle tables into ascii files (delimited). If it is possible thru any was please let me know urgently....

With regards.
Umesh Sharma
sharmaumesh@chequemail.com

Report message to a moderator

Re: Writing data from oracle tables into ascii files... [message #368064 is a reply to message #368063]

Mon, 14 February 2000 04:38

Thomas
Messages: 67
Registered: September 1999

Member

Hi,
there is no utility from Oracle like "unload" in Informix, but with a bit of SQL you can get it done.
it's like
select "'"| name |"'"|, nickname |"'" from users;

hope that helps

regards Thomas

Report message to a moderator

Re: Writing data from oracle tables into ascii files... [message #368066 is a reply to message #368063]

Tue, 15 February 2000 19:10

Phil P
Messages: 5
Registered: February 2000

Junior Member

I've posted a script that will dump a table delimited as you specify to an ascii file and also build a sqlldr control file to load it back in. To see it, login to my homepage, http://home.earthlink.net/~ppadgett and follow the career then code links.
Hope this helps.

Report message to a moderator

Previous Topic:	Re: export and consistent=Y
Next Topic:	Re: SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 22:04:07 CDT 2024