Breaking News: Grepper is joining You.com. Read the official announcement!

ORA-02354 and ORA-01555

yN7ka answered on June 10, 2022 Popularity 1/10 Helpfulness 1/10

answer ORA-02354 and ORA-01555

ORA-02354 and ORA-01555

Comment

ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 'Nº' with name "_SYS*/" too small

For most of cases is just necessarily increase space allocated to UNDO.

SELECT STATUS,FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024/1024,MAXBYTES/1024/1024/1024,INCREMENT_BY,AUTOEXTENSIBLE FROM DBA_DATA_FILES WHERE TABLESPACE_NAME like '%UNDO%';
SHOW PARAMETER UNDO_RETENTION;
ALTER SYSTEM SET UNDO_RETENTION=1800;

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Jun 10 2022

yN7ka

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

ORA-02354 and ORA-01555

Contents

More Related Answers

ORA-02354 and ORA-01555

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.