DBA_OBJECTS

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022March 21, 2023

LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… 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 »

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 »