DB02 Refresh Issue

If you changed something on database level of your SAP system , DB02 transaction couldn’t realize that immediately.. If you need this then check the steps below…

For an example , we have deleted the tablespace PSAPSR3731 from our database

Let’s check it from SQLPLUS ,

SQL> Select TABLESPACE_NAME from dba_tablespaces;

DB02 Refresh Issue

No tablespace have shown after this sql query , now we are going to check it from DB02 transaction ;

DB02 Refresh Issue

Tablespace PSAPSR3731 normally not exist anymore but DB02 couldn’t realize that.

Now we should try to click “Refresh” button of the screen

DB02 Refresh Issue

This action will trigger the following background job ;

REFRESH SPACE STATISTIC:DEFAULT

DB02 Refresh Issue

After the job completed  , you can see the actual situation of your database on DB02 screen

DB02 Refresh Issue

Also if you need to do this action manually for any case then you can execute the following SAP program on SE38 transaction

Program Name –> RSORACOLR

DB02 Refresh Issue

DB02 Refresh Issue

 

Leave a Reply


9 − three =

Blogroll