-
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.
-
yet you dont mention what versions you are using, and how you are exporting
-
Server is 9.2.0.8 and client is 9.2.0.1. I am doing a user level export with compress=Y.
Thanks.
-
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|