Getting ORA-25153: Temporary Tablespace is Empty when running expdp

Apr 28, 2022 5:32PM

Hello,

Oracle 19c Version 19.11.0.0.0

After failing over to the DataGuard standby, the data pump export for one database is failing with

this error: ORA-25153: Temporary Tablespace is Empty

All articles suggest the tempfile is missing, but it is present. Grateful for your help.

select FILE#,STATUS,ENABLED,NAME from v$tempfile;

FILE# STATUS ENABLED

---------- ------- ----------

NAME

--------------------------------------------------------------------------------

1 ONLINE READ WRITE

+DATA/CDBGDPQDR/TEMPFILE/temp.300.1091895669

2 ONLINE READ WRITE

+DATA/CDBGDPQDR/C8E309CF1244304CE0535902F90ABF21/TEMPFILE/temp.299.1091895673

select tablespace_name,file_name,bytes/1024/1024 from dba_temp_files;

TABLESPACE_NAME

------------------------------

FILE_NAME

----------------------------------------------------------------------------------------------------

BYTES/1024/1024

---------------

TEMP

+DATA/CDBGDPQDR/TEMPFILE/temp.300.1091895669

Database Administration (MOSC)