DROP TABLESPACE

How to Resolve ORA-01258: unable to delete temporary file

by Ed Chen
November 8, 2022March 20, 2023

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-12906: cannot drop default temporary tablespace

by Ed Chen
September 1, 2022July 27, 2022

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-12919: Can not drop the default permanent tablespace

by Ed Chen
August 31, 2022October 8, 2022

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 »

Drop Tablespace Examples

by Ed Chen
August 30, 2022July 27, 2022

We take the following steps to drop a tablespace. 1. Make Sure Non-Default The tablespace that we want to drop must not be the default… Read More »

How to Resolve ORA-22868: table with LOBs contains segments in different tablespaces

by Ed Chen
January 26, 2022March 20, 2023

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-23515: materialized views and/or their indices exist in the tablespace

by Ed Chen
January 24, 2022March 20, 2023

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-29857: domain indexes and/or secondary objects exist in the tablespace

by Ed Chen
January 21, 2022March 20, 2023

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 Empty an Oracle Database

by Ed Chen
January 8, 2020March 20, 2023

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 »