Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1283082
  • 博文数量: 3010
  • 博客积分: 10011
  • 博客等级: 上将
  • 技术积分: 30431
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-27 11:53
文章分类

全部博文(3010)

文章存档

2008年(3010)

我的朋友

分类: LINUX

2008-05-27 16:38:57

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 下载地址
阅读(135) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~