Posts

ORA-31693: Table data object failed to load/unload

ORA-31693: Table data object failed to load/unload ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" failed to load/unload (LOB Table) The export backup (expdp) are logical database backups that extract logical definitions and data from the database to a file. Export backups are cross-platform and can be easily moved from one operating system to the other. When exporting a database backup using Data Pump (expdp), and all is exporting fine, except for one table it fails to export with the following errors: ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" 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 154 with name "<ROLLBACK_SEGMENT_NAME>" too small   Here Table is LOB table, Check the LOB corruption. if no corruption is found in the LOB then may be the LOB Retention ...
Post a Comment
Read more

ORA-02374: Conversion error loading table, ORA-02374: Conversion error loading table during impdp

Image
ORA-02374: Conversion error loading table, ORA-02374: Conversion error loading table during impdp During import data through impdp on target database facing the below error:- ORA -02374 : conversion error loading table "FINNONELOS" . "LOS_DEDUPE_CUSTOMER_HST" ORA -12899 : value too large for column PROPERTY_ADDR1 ( actual : 102 , maximum : 100 )   ORA -02372 : data for row : PROPERTY_ADDR1 : 0 X '464C4154204E4F2E203530312C203520544820464C4F4F5220'   Import completed with error [ i.e partially imported data in "FINNONELOS"."LOS_DEDUPE_CUSTOMER_HST table] Follow the below steps for the solution:- o    Describe the table and modify the column size accordingly. SQL > desc FINNONELOS . LOS_DEDUPE_CUSTOMER_HST   Name                            ...
Post a Comment
Read more