Mike Ault, «Documenting Oracle Databases»

Posted By: Alexpal
Mike Ault, «Documenting Oracle Databases»

Mike Ault, «Documenting Oracle Databases»
Rampant TechPress | ISBN 0974071668 | 2003 Year | PDF | 1,1 Mb | 95 Pages

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 re-generate the required DDL.

This presentation will demonstrate techniques to use the Oracle instance to document itself.


Бонус | Bonus
My other uploaded eBooks (1900+) - links and descriptions
Другие книги, закаченные мной (более 1900) - ссылки и библиографические данные

New! version 6 (May 03 2006) [1,1 Mb] | Format: txt

Download eBooks list from Mytempdir
Download eBooks list from Rapidshare

If you need a book from the li...рабочих ссылках в моих постах.