Home » RDBMS Server » Server Utilities » Unable to export Table having CLOB data type
Unable to export Table having CLOB data type [message #245939] Tue, 19 June 2007 06:46 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi All

I am trying to copy the data from table T1 to excel sheet which has a column with the data type CLOB.

For this i have used Oracle loader tool which says that CLOB data type is not supported,

How can i migrate a table as is which is having CLOB data type..

Thanks in advance.

Re: Unable to export Table having CLOB data type [message #245953 is a reply to message #245939] Tue, 19 June 2007 07:17 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
I am not sure, but I think that You a create an external table, export data into them, and read them by Excel.
Re: Unable to export Table having CLOB data type [message #245961 is a reply to message #245939] Tue, 19 June 2007 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am trying to copy the data from table T1 to excel sheet which has a column with the data type CLOB.
For this i have used Oracle loader tool which says that CLOB data type is not supported

If you want to unload them SQL*Loader is useless as its purpose is to load.

Regards
Michel
Re: Unable to export Table having CLOB data type [message #245976 is a reply to message #245961] Tue, 19 June 2007 08:20 Go to previous messageGo to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Then, How can i export a table data having CLOB column to Excel sheet.
Is not there any way to do it in Oracle?

Please suggest me on this..

Thanks
Re: Unable to export Table having CLOB data type [message #245994 is a reply to message #245976] Tue, 19 June 2007 09:13 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Goto AskTom and search for "unloader".

Regards
Michel
Previous Topic: SQL Loader Issue
Next Topic: impdp REAMP_DATAFILE arghhhh
Goto Forum:
  


Current Time: Mon Dec 05 21:04:57 CST 2016

Total time taken to generate the page: 0.09061 seconds