Skip to Content
0
Former Member
Sep 17, 2007 at 11:12 AM

ORA-25153: Temporary Tablespace is Empty After Database Copy

3411 Views

Hi Gurus ,

I have resently Copied my Production database to quality databse.

After the copy i am getting the following dump in st22 in the Quality system.

<b>Runtime Error</b>: DBIF_RSQL_SQL_ERROR

<b>Except</b>.: CX_SY_OPEN_SQL_DB

<b>ShrtText</b> :An SQL error occurred when accessing a table.

<b>How to correct the error</b>

Database error text........: "ORA-25153: Temporary Tablespace is Empty"

Internal call code.........: "[RSQL/FTCH//SAPAPO/V_TRPROD ]".

Also , in the db02 of Quality the "PSAPTEMP" is showing 0KB size.

If trying to add new data file , it gives an error as file already exists.

Please suggest...

Regards

Anthony