CAN ORACLE MANAGED TABLESPACES DROPPED?

No they cannot be dropped due to each tablespace’s utility for different purpose. But for some tablespace’s a counter tablespace can be created and existing tablespace can be dropped like undo, temp etc.. But system and sysaux are critical for database functioning and they are brain and heart of oracle database

kIsH@Xhydra<>drop tablespace users including contents and datafiles;
drop tablespace users including contents and datafiles
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace


kIsH@Xhydra<>drop tablespace system including contents and datafiles;
drop tablespace system including contents and datafiles
*
ERROR at line 1:
ORA-01550: cannot drop system tablespace


kIsH@Xhydra<>drop tablespace temp including contents and datafiles;
drop tablespace temp including contents and datafiles
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace


kIsH@Xhydra<>drop tablespace sysaux including contents and datafiles;
drop tablespace sysaux including contents and datafiles
*
ERROR at line 1:
ORA-13501: Cannot drop SYSAUX tablespace

kIsH@Xhydra<>drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

Leave a Reply