Datapump export Backup error with ORA-01555 and ORA-39029:

Jan 7, 2019 1:54AM

Hi,

Please help to investigate below error.

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 7 14:53:27 2019

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show parameter undo

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
undo_management              string    AUTO
undo_retention               integer   9000
undo_tablespace              string    UNDOTPS2

SQL> l
1* select file_name,bytes/1024/1024,AUTOEXTENSIBLE from dba_data_files where tablespace_name ='UNDOTPS2'
SQL> /

FILE_NAME                                    BYTES/1024/1024 AUT
------------------------------------------------------------ --------------- ---
/home/oracle/product/10.2.0/oradata/orcl/UNDOTP02_1.dbf                10000 YES
/home/oracle/product/10.2.0/oradata/orcl/UNDOTP02.dbf                  32000 YES

Error message:

Export: Release 10.2.0.1.0 - Production on Monday, 07 January, 2019 7:30:02

Database Backup and Recovery (MOSC)

Datapump export Backup error with ORA-01555 and ORA-39029:

Howdy, Stranger!

Category Leaderboard

Top contributors this month