DBA_TABLES

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 Check Oracle Table Size

by Ed Chen
September 25, 2019December 10, 2022

The size of an Oracle table can be calculated by different ways. In this post, I will introduce 3 approaches, theoretical table sizing, logical table… Read More »

Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES

How to List All Tables in Oracle

by Ed Chen
August 23, 2018December 10, 2022
2 Comments

In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… 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 »

JavaScript is not enabled. Please enable it and reload the page.