Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle data dictionary scripts in this concise download.  With decades of experience using Oracle schema scripts and Oracle documentation scripts, Mike Ault shares secrets for navigating the Oracle data dictionary.

This fantastic download allows you to quickly find sample Oracle scripts using v$ structures including v$parameter, v$logfile, v$log, v$enabledprivs, v$rollname and v$rollstat.  Sample Oracle schema scripts include DBA data dictionary views including dba_data_files, dba_tablespaces, dba_rollback_segs, dba_roles, dba_role_privs, dba_sys_grants, dba_col_privs, dba_users, dba_ts_quotas, dba_tables, dba_tab_columns, dba_indexes, dba_ind_columns, dba_sequences, dba_objects, dba_source, dba_triggers, dba_trigger_cols, dba_views, dba_snapshot_logs, dba_snapshots, dba_free_space, dba_profiles, dba_sys_privs, dba_tab_privs, dba_clusters, dba_clu_columns, dba_constraints, dba_cons_columns and dba_db_links

Caution - These are extremely powerful Oracle data dictionary scripts.  They should only be used by a certified Oracle DBA, and after a careful review of the Oracle data dictionary script functionality.  These Oracle scripts are not for beginners and knowledge of the Oracle data dictionary is required to fully utilize these scripts.  USE AT YOUR OWN RISK.

Key Features:

• Provides detailed data dictionary scripts for all Oracle schema objects.

• Provides Oracle table scripts with dba_tables, dba_tab_columns, dba_tab_privs, dba_triggers, dba_trigger_cols, dba_views, dba_constraints and dba_cons_columns.

• Oracle cluster table scripts with dba_clusters and dba_clu_columns.

• Oracle index information from dba_indexes and dba_ind_columns.

• Database link scripts with dba_db_links.

• Oracle replication scripts with dba_snapshots and dba_snapshot_logs.

• Oracle security audit scripts with dba_roles, dba_role_privs, dba_profiles, dba_sys_privs, dba_sys_grants.

• Oracle tablespace and Oracle file scripts using dba_tablespaces, dba_data_files, dba_extents, dba_rollback_segs and dba_free_space.

• Oracle rollback segment scripts using v$log, v$rollstat, v$rollname and dba_rollback_segs.

• Oracle user auditing scripts using v$enabledprivs, dba_roles, dba_role_privs, dba_sys_grants, dba_col_privs, dba_users, dba_ts_quotas, dba_profiles, dba_sys_privs and dba_tab_privs.

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.