Getting ORA-01555: snapshot too old: ORA-02354: error in exporting/importing data error during expdp

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

  1. You can increase temp tablespace (the easy way)
  2. 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)

 

Reklam


Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Connecting to %s

%d blogcu bunu beğendi: