Drop tablespace

[Former Member]

Hello,

I need to delete a TS. TS is empty and I´ve executed the brspace –f tsdrop

BR0280I BRSPACE time stamp: 2014-01-15 19.08.38
BR1016I SQL statement 'drop tablespace PSAPSR3701' executed successfully

BR1069I Tablespace PSAPSR3701 dropped successfully
BR0280I BRSPACE time stamp: 2014-01-15 19.09.38
BR0641I Deletion of database file 'C:\ORACLE\SID\SAPDATA3\SR3701_1\SR3701.DATA1' waiting for releasing it by Oracle...
BR0280I BRSPACE time stamp: 2014-01-15 19.10.38
BR0641I Deletion of database file 'C:\ORACLE\SID\SAPDATA3\SR3701_1\SR3701.DATA1'waiting for releasing it by Oracle...

BR0253W errno 13: Permission denied

BR0252W Function _rmdir() failed for 'C:\ORACLE\SID\SAPDATA3\SR3701_5' at locati

on BrDirDelete-6

BR0253W errno 41: Directory not empty

And It´s doing for each datafile. What can I do?

[Former Member · Accepted solution]

Hi Ruben

looks like the TB deleted from oracle level - but the issue happened in the removal of the data file from the OS Level ..

Are you able to check if the table space exists for you at all currently in the SAP ( from DB02 ) ..

Also please check these links  regarding this specific tablespace

1848753 - SUM 1.0: exchange tablespace (e.g. PSAPSR3702X) handling during release upgrade/update

Thanks

Rishi

[Former Member · Accepted solution]

I´ve checked with this sql

select table_name from dba_tables where tablespace_name='PSAPSR3701';

select index_name from dba_indexes where tablespace_name='PSAPSR3701';

And it's empty this tablespace because I´ve done the reorganize to the new tablespace.

On dbacockpit the old tablespace doesn't appear because the TS was dropped, the screenshot show the execution of the command successfully.

In the follow-up activities says to execute brspace –f tsdrop command.

So I'm getting some doubts...

I need to execute the brspace command with sap instance stopped?

What will be deleted? Datafile, folder SR3701? Folder SAPDATA3?

How can I check if I have  deferred segment creation active option of Oracle11g?If I´ve checked that the TS is empty with the differentes sql commands Could I sure that are empty really?

[Reagan · Accepted solution]

It is very obvious in the brspace log file that the tablespace PSAPSR3701 is empty.

I did reply in the other thread that BRtools will warn you if there are some objects left in the tablespace.

The problem you have right now is mostly related to the OS. There must be some process at the OS level having some handles on these files.

That is the reason I suggested to stop SAP and Oracle before you delete them.

Moreover the tablespace has already been dropped.

You can go to the sapdata3 directory and rename/move the datafiles and try starting the Oracle.

If the database start well then query the database for the tablespace and also for the datafile to check whether the database still sees them.

Regards

RB

[Reagan]

Stop SAP and Oracle.

If possible restart Windows.

Start just Oracle and drop the tablespace.

Check the alert log to find more information.

Regards

RB