Drop tablespace

[Former Member]

Hello,

I was trying to install the EHP5 but I can not do now. I had to restart the installation of EHP5. Now I find that I have a tablespace with 3 datafiles PSAPSR3701X and there are empty.

Now I find that when making backups of the database in the destination folder I need more space, which need to delete the tablespace or datafiles that exist in the tablespace.

Is there any problem when needed create again PSAPSR3701X tablespace?

Thank you very much

I´ve encountered this options

SQL> DROP TABLESPACE PSAPPRD701 INCLUDING CONTENTS AND DATAFILES;

And the other side the brtools.

Which is the most secure?

With this command drop the tablespace and all under of therer,not?

Once a time the tablespace has been dropped can create once again with the same name?

Edited by: Ruben Torres on Feb 28, 2011 4:33 PM

Edited by: Ruben Torres on Feb 28, 2011 4:44 PM

[Vivek_Hegde · Accepted solution]

Hello Ruben,

If you want the tablespace information to be accurate on R/3 then you can execute database check job from DB13.

It will refresh the information of your database and updates DB02.

Regards

Vivek

Edited by: VivekHegde on Mar 2, 2011 11:30 AM

[Former Member · Accepted solution]

Exactly, today when I logged on the system the tablespace not appear in DB02.

But the space ocupped on the system still remains the space ocuped.

[former_member204746 · Accepted solution]

you might need to restart the database, then, if these files still exist, check their time stamps. if they are not the same as other datafiles, you can delete them at Os level.

[Former Member]

Just curious. Why do you want to drop it? It will be needed for EHP5 based on previous size estimates. isn't it?

[Former Member]

Yes, but in this moment I cannot install EHP5, and not have enough disk space for to do the backup.

Edited by: Ruben Torres on Feb 28, 2011 5:29 PM

[former_member204746]

ok then,

if they are empty and you do not need them ,you can drop them.

[Former Member]

But in the future, I´ll need to create again this tablespace with the same name for to do the EHP5 installation. There are a problem??

[Vivek_Hegde]

Hi,

You can recreate the tablespace with same name later if you want to.

Regards

Vivek

[Former Member]

I´ve execute the comand

DROP TABLESPACE PSAPSR3701X INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

But the space occuped remains still. On the DB02 appear the tablespace.

What can i do?

More thanks

[former_member204746]

DB02 DOES NOT contain up-to-date information. it gets updated twice a day, usually 7am and 7pm.

rely on BRTOOLS to really see the actual status.

[former_member204746]

use BRTOOLS to be safer... .but at the end, the same command will be executed.