DBA_SEGMENTS

How to Resolve ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

by Ed Chen
September 2, 2022October 20, 2022

ORA-01549 Tried to drop a tablespace in the simplest way, but it failed with ORA-01549. SQL> drop tablespace erptbs; drop tablespace erptbs * ERROR at… Read More »

What Tables are in a Tablespace

by Ed Chen
June 3, 2022March 20, 2023

We have talked about the differences between schema objects and segments in another post. From tablespace's point of view, program units and informative schema objects… Read More »

Which Tablespace of the Table

by Ed Chen
June 1, 2022March 20, 2023

Table Resides in What Tablespace? To better manage overall tablespace usage, we'd like to know which tablespace specific table or index is in before moving… 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 »

How to Check Oracle Database Size

by Ed Chen
August 30, 2019December 10, 2022

At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »

Segments vs Schema Objects

by Ed Chen
July 20, 2019December 10, 2022

Segments vs Schema Objects Not only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions… Read More »

How to Check Oracle Segment Size

by Ed Chen
January 14, 2019December 10, 2022

Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »

How to Find Biggest Tables in Oracle

by Ed Chen
January 8, 2019December 10, 2022

Top 10 Biggest Tables in Whole Database When the disk space is running out, you might want to calculate Oracle table size and list the… 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 »