The following errors in Oracle database exp export data, how to solve?-CodePudding

ORA - 24801: illegal parameter value in OCI lob function, the error of the table contains the clob fields, but there are other clob fields table also has export success

CodePudding user response:

The client version? What server version?
Export command post

CodePudding user response:

The

reference 1/f, CKC response:

client version? What server version?
Export command post to see

this is part of the export log began, export orders are: exp XX XX file=@ * *. DMP log=* *. The log owner=eop_stat, eop_conf, eop_sm buffer=800000000 CONSISTENT=y

CodePudding user response:

The export CONTRACT_ADAPTER20150127 this form error, put the table structure

CodePudding user response:

Online search, it seems like a more complex error, a variety of situations, only know errors related to clob,
If I encounter such a situation, I would try the following methods:
In a client
Remove the CONSISTENT parameter
Remove the buffer parameter
Export only a single user data
In use expdp

CodePudding user response:

CKC quote 4 floor response:

search on the net, it seems like a more complex error, a variety of situations, only know errors related to clob,
If I encounter such a situation, I would try the following methods:
In a client
Remove the CONSISTENT parameter
Remove the buffer parameter
Export only a single user data
In use expdp

thank you, then I asked a colleague, a data table contains clob fields, to use expdb command to backup

CodePudding user response:

reference yaiger reply: 3/f

in export CONTRACT_ADAPTER20150127 this form error, put the table structure

thank you, then I asked a colleague, a data table contains clob fields, to use expdb command to backup

CodePudding user response:

refer to 6th floor GrassRing1 response:

Quote: refer to the third floor yaiger response:

In export CONTRACT_ADAPTER20150127 this form error, put the table structure

thank you, then I asked a colleague, a data table contains clob fields, to use expdb command to backup

There is no thing, but relative to exp, more it is recommended to use expdp

CodePudding user response:

refer to 7th floor minsic78 response:

Quote: refer to the sixth floor GrassRing1 response:

Quote: refer to the third floor yaiger response:

In export CONTRACT_ADAPTER20150127 this form error, put the table structure

thank you, then I asked a colleague, a data table contains clob fields, to use expdb command to backup

This is not the matter, but relative to exp, especially recommended expdp

expdb is only native backup, not the remote server to backup?

CodePudding user response:

refer to the eighth floor GrassRing1 response:

Quote: refer to 7th floor minsic78 response:

Quote: refer to the sixth floor GrassRing1 response:

Quote: refer to the third floor yaiger response:

In export CONTRACT_ADAPTER20150127 this form error, put the table structure

thank you, then I asked a colleague, a data table contains clob fields, to use expdb command to backup

This is not the matter, but relative to exp, especially recommended expdp

expdb is only native backup, not the remote server to backup?

B: yes, so sometimes have to back to exp, of course, you can create conditions, as far as possible or use expdp

CodePudding user response:

Lob data exp can export, export expdp can also be on the client