Oracle 9i Copy CLOB data

Printable View

07-22-2008, 04:58 PM
rshivagami

Oracle 9i Copy CLOB data

I need to copy data from one database to another and one of the tables has CLOB datatype. Exporting throws an error "EXP-00003: no storage definition found for segment(5, 45443)" which I believe is due to the client and server being different oracle versions. What are my options ? SQLPLUS COPY command fails with the error "CPY0012: Object datatypes cannot be copied".

Thanks.
07-22-2008, 05:18 PM
davey23uk

yet you dont mention what versions you are using, and how you are exporting
07-22-2008, 09:59 PM
rshivagami

Server is 9.2.0.8 and client is 9.2.0.1. I am doing a user level export with compress=Y.

Thanks.
07-23-2008, 03:57 AM
PAVB

Look at DBMS_LOB
07-23-2008, 04:33 AM
davey23uk

well export will export clobs, so you are doing something wrong -

post full commands, and any reason why our client release isnt the same as the database release?

All times are GMT -4. The time now is 10:15 AM.