How to List Tables in Data File
Normally, we would like to know what objects in a tablespace for better managing object allocation. In fact, a tablespace is just a logical collection… Read More »How to List Tables in Data File
Segment
How to List Tables in Tablespace
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 »How to List Tables in Tablespace
Segments vs Schema Objects
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 »Segments vs Schema Objects
How to Check Oracle Segment Size
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 Check Oracle Segment Size