DBA_, ALL_ and USER_ Views You may think all dictionary views have their corresponding ones in different sets or scopes. For example, I'd like to… Read More »Data Dictionary View Sets Comparison
ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »How Oracle Search View Text in ALL_VIEWS
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
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 »How to List All Tables in Oracle