DBA_INDEXES

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 »

Must Dos after Moving a Table

by Ed Chen
April 16, 2016July 3, 2019

Moving a table is actually a reorganization process, The database will copy the original data to the new place. In which, the data will be… Read More »