Oracle Database objects like packages, procedures, procedure columns, functions, indexes, tables, schemas, views

Tables :-

select table_name,owner from sys.all_tables order by owner,table_name;

select table_name,owner from sys.all_tables where owner='schema_name' order by table_name;

Schemas:-

select username from sys.all_users order by username;

Views :-

select view_name,owner from sys.all_views order by owner,view_name;

Packages:-

select object_name,owner from sys.all_objects where upper(object_type) =upper('PACKAGE')

order by owner, object_name;

Procedures:-

select object_name,owner from sys.all_objects where upper(object_type) =upper('PROCEDURE')

order by owner,object_name;

Procedure Columns:-

select owner,object_name,argument_name,data_type,in_out from sys.all_arguments

order by owber,object_name,sequence;

Functions:-

select object_name,owner from sys.all_objects where upper(object_type) = upper('FUNCTION')

order by owner,object_name;

Indexes:-

select index_name,table_name,table_owner from sys.all_indexes order by table_owner,table_name,index_name;

Nonschema objects :-

• Contexts
• Directories
• Editions
• Flashback archives
• Lockdown profiles
• Profiles
• Restore points
• Roles
• Rollback segments
• Tablespaces
• Tablespace sets
• Unified audit policies
• Users

Schema objects:-

• Analytic views
• Attribute dimensions
• Clusters
• Constraints
• Database links
• Database triggers
• Dimensions
• External procedure libraries
• Hierarchies
• Index-organized tables
• Indexes
• Indextypes
• Java classes
• Java resources
• Java sources
• Join groups
• Materialized views
• Materialized view logs
• Mining models
• Object tables
• Object types
• Object views
• Operators
• Packages
• Sequences
• Stored functions
• Stored procedures
• Synonyms
• Tables
• Views
• Zone maps

all_dependencies

all_db_links

all_directories

all_errors

all_goldengate_rules

all_goldengate_privileges

all_jobs

all_libraries

all_lobs

all_mviews

all_objects

all_blockchain_tables

all_catalog

all_certificates

all_constraints

all_credentials

gv$session

gv$session_longops