电子书免费下载 Documenting Oracle Databases Complete Oracle database schema auditing

Many times the Oracle DBA is hired once the database becomes to much to handle without one, inherits the position or is appointed to it “since they are so good with computers”. In any case, they usually get an undocumented system that follows no conventions and holds many traps for the unwary DBA.

In other situations the DBA may find they have the task of recreating the database for which they are responsible. If export and import can be used, this task is fairly easy to accomplish, however, sometimes the DBA will be required to provide DDL (Data Definition Language) for this purpose. The DBA may also wish to document existing procedures, views, constraints and such other structures as they see fit, with human readable output and a minimum of re-editing.

In all of the above cases, the Oracle provided methods fall woefully short of the mark in providing the DBA with documentation. It falls on the DBA’s shoulders to develop SQL, PL/SQL and SQLPLUS code to delve into the inner workings of the Oracle Data Dictionary tables and regenerate the required DDL.

This presentation will demonstrate techniques to use the Oracle instance to

document itself.

Documenting Oracle Databases Complete Oracle database schema auditing 下载地址