Skip to Content
0
Former Member
Feb 28, 2011 at 02:55 PM

Drop tablespace

38 Views

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