Home » SQL & PL/SQL » SQL & PL/SQL » How to extract CLOB data into text file? (Oracle 9i)
How to extract CLOB data into text file? [message #403948] Tue, 19 May 2009 15:23 Go to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Hi,
Could you please guide me how to extract CLOB data into text file?
I am trying to get table/view extract and one of column is CLOB and i am having hard time to get text file data?

Appreciated you help!

Thanks,
Re: How to extract CLOB data into text file? [message #403949 is a reply to message #403948] Tue, 19 May 2009 15:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i am having hard time to get text file data?

That does not help us either.
Post the exact issue.
Did you search?
The web and this forum is full of it.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:744825627183
Re: How to extract CLOB data into text file? [message #403953 is a reply to message #403949] Tue, 19 May 2009 16:28 Go to previous messageGo to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Thanks Mahesh.
I tried to find it out on Google but didn't help much as some of with 3rd party solution and couple i found with UTL but we haven't set up UTL directory.

I will search this forum.

Thanks for your response.


Re: How to extract CLOB data into text file? [message #403999 is a reply to message #403953] Wed, 20 May 2009 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but we haven't set up UTL directory.

You have not, just create an Oracle DIRECTORY object.

Regards
Michel
Re: How to extract CLOB data into text file? [message #404211 is a reply to message #403999] Wed, 20 May 2009 21:30 Go to previous messageGo to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Thanks Michel.
After setting up Directory what will be the next set up?

Thanks for your help!
Re: How to extract CLOB data into text file? [message #404212 is a reply to message #403948] Wed, 20 May 2009 22:14 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+clob+to+text+file
Previous Topic: MAX Analytical Function on Date
Next Topic: Find a value in more than a table
Goto Forum:
  


Current Time: Sun Dec 04 04:19:30 CST 2016

Total time taken to generate the page: 0.16387 seconds