You may hit with that error code during the export process. I faced with those error on Oracle 12c database.
Complete error messages are:
ORA-31693: Table data object "SCHEMA"."TABLE_NAME_HERE" 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 21 with name "_SYSSMU21_2773200038$" too small
For fix that issue You may try below steps
- You can increase temp tablespace (the easy way)
- If you still hitting the same errors then you can follow:
SQL> show parameter UNDO_RETENTION NAME TYPE VALUE ---------------- -------- ---------- undo_retention integer 900 SQL> ALTER SYSTEM SET UNDO_RETENTION = 2100 scope=both sid='*'; System altered. SQL> show parameter UNDO_RETENTION NAME TYPE VALUE ---------------- ------- ------------- undo_retention integer 2100
3. If your table has LOB segment then you can Modify the LOB retention to become greater than the undersized retention parameter following the steps(Details available at Note:563470.1)
- SQL> alter table SCHEMA.TABLE modify lob(FILE_DATA) (pctversion 5);
Table altered.SQL> alter table SCHEMA.TABLE modify lob(FILE_DATA) (retention);
Table altered. - Query the lob retention again to verify that the change has taken hold:
SQL> select retention from dba_lobs where owner='SCHEMA' and table_name='TABLE '; RETENTION ---------- 2100
Reference:Data Pump Export Fails With ORA-31693 ORA-02354 and ORA-01555 Errors And No LOB Corruption (Doc ID 1507116.1)
Bir Cevap Yazın