OraFAQ Forum: Server Utilities » Unable to export Table having CLOB data type

Home » RDBMS Server » Server Utilities » Unable to export Table having CLOB data type

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

Unable to export Table having CLOB data type [message #245939]

Tue, 19 June 2007 06:46

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.

Report message to a moderator

Re: Unable to export Table having CLOB data type [message #245953 is a reply to message #245939]

Tue, 19 June 2007 07:17

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.

Report message to a moderator

Re: Unable to export Table having CLOB data type [message #245961 is a reply to message #245939]

Tue, 19 June 2007 07:26

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Unable to export Table having CLOB data type [message #245976 is a reply to message #245961]

Tue, 19 June 2007 08:20

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

Report message to a moderator

Re: Unable to export Table having CLOB data type [message #245994 is a reply to message #245976]

Tue, 19 June 2007 09:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Goto AskTom and search for "unloader".

Regards
Michel

Report message to a moderator

Previous Topic:	SQL Loader Issue
Next Topic:	impdp REAMP_DATAFILE arghhhh

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 05:59:16 CST 2025