How to Drop Empty Tablespace
In previous post, we have talked about how to identify empty tablespaces for dropping. In that post, we cautiously check the status of the tablespace… Read More »How to Drop Empty Tablespace
DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES
How to Resolve ORA-30012: undo tablespace does not exist or of wrong type
ORA-30012 Tried to restart a normal, typical database after changing the default undo tablespace, but it failed with ORA-30012. SQL> startup ORACLE instance started. ...… Read More »How to Resolve ORA-30012: undo tablespace does not exist or of wrong type
How to Resolve ORA-01258: unable to delete temporary file
ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… Read More »How to Resolve ORA-01258: unable to delete temporary file
How to Resolve ORA-12906: cannot drop default temporary tablespace
ORA-12906 Tried to drop a temporary tablespace, but it failed with ORA-12906. SQL> drop tablespace temp1 including contents and datafiles; drop tablespace temp1 including contents… Read More »How to Resolve ORA-12906: cannot drop default temporary tablespace
How to Resolve ORA-12919: Can not drop the default permanent tablespace
ORA-12919 Tried to drop a tablespace, but it failed with ORA-12919. SQL> drop tablespace erptbs including contents and datafiles; drop tablespace erptbs including contents and… Read More »How to Resolve ORA-12919: Can not drop the default permanent tablespace
Drop Tablespace Examples
We take the following steps to drop a tablespace. Make Sure Tablespace is Non-Default Take Tablespace Offline Make Sure Tablespace is Empty Drop a Tablespace… Read More »Drop Tablespace Examples
How to Resolve ORA-22868: table with LOBs contains segments in different tablespaces
ORA-22868 Saw error ORA-22868 when I tried to drop a tablespace cascadingly. SQL> drop tablespace ERP_TBS01 including contents and datafiles cascade constraints; drop tablespace ERP_TBS01… Read More »How to Resolve ORA-22868: table with LOBs contains segments in different tablespaces
How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace
ORA-23515 Tried to drop a tablespace from the database in order to reclaim some space, but it failed with ORA-23515. SQL> drop tablespace example including… Read More »How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace
How to Resolve ORA-29857: domain indexes and/or secondary objects exist in the tablespace
ORA-29857 Tried to drop a tablespace from the database in order to reclaim some space, but it failed with ORA-29857. SQL> drop tablespace example including… Read More »How to Resolve ORA-29857: domain indexes and/or secondary objects exist in the tablespace
How to Empty an Oracle Database
Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »How to Empty an Oracle Database