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