How to solve the problem of EXPDP Times wrong ORA-31693
This article mainly explains "how to solve the wrong ORA-31693 of EXPDP Times". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the wrong ORA-31693 of EXPDP Times".
When you import a table that holds photos on the server, the following error message is reported:
ORA-31693: Table data object "LBS". "T_MSG_IMAGE" failed to load/unload and is being skipped due
To error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 66 with name "_ SYSSMU66 $" too small
Using the data pump to export the database big table Times error:
ORA-31693: the table data object "* *". "* *" cannot be loaded / unloaded and skipped, the error is as follows:
ORA-02354: error exporting / importing data
ORA-01555: snapshot is too old: fallback segment number (name "") is too small
I checked your answers, and the main reason is that the setting of the rollback section is too small.
Explanation: when you export or query a table, other users make row changes to the table.
After the modification is submitted, the old data is usually retained in the UNDO to ensure that the data is read consistently.
If the UNDO retention time is up and there is not enough space in the UNDO, the old data in the UNDO will be overwritten. Operations that rely on this data cannot get a consistent read, thus reporting an error: ORA-01555
It is recommended to modify undo_retention and undo tablespace size to the appropriate size.
Or select the database idle time period to execute the expdp job
Modify statement: alter system set undo_retention=36000 scope=both
Thank you for reading, the above is the content of "how to solve EXPDP Times wrong ORA-31693". After the study of this article, I believe you have a deeper understanding of how to solve the problem of EXPDP Times wrong ORA-31693, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
