您当前的位置: 首页 >  sql

qq_34412985

暂无认证

  • 0浏览

    0关注

    1061博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

$ORACLE_HOME\RDBMS\ADMIN目录下各SQL的含义

qq_34412985 发布时间:2020-08-28 18:11:09 ,浏览量:0

$ORACLE_HOMERDBMSADMIN目录下各SQL的含义

catalog.sql - create data dictionary views. cataudit.sql - data dictionary views for auditing. (catnoaud.sql will remove) catblock.sql - create views of oracle locks catclust.sql - create cluster database specific views definitions catdbsyn.sql - catalog dba synonyms (dba_synonyms.sql) catexp7.sql - create v7 style. export/import views catexp81.sql - create internal views for export/import utility catio.sql - collect i/o per table/object stats by statistical sampling catjava.sql - catalog scripts for java catjobq.sql - catalog views for the job queue catjvm.sql - create user|dba|all_java_* views catldap.sql - catalog for ldap pl/sql api catldr.sql - views for the direct path of the loader catlsby.sql - logical standby tables and views catpart.sql - creates data dictionary views for the partitioning table. catoctk.sql - catalog - oracle cryptographic toolkit catol.sql - outline views and synonyms catparr.sql - parallel-server specific views, performance queries, etc catpatch.sql - script. to apply catalog patch set catpitr.sql - tablespace point in time specific views catplug.sql - pluggable tablespace check views catprc.sql - creates data dictionary views for types, stored procedures, and triggers. catproc.sql - run all sql scripts for the procedural option catqm.sql - creates the tables and views needed to run the xdb system catqueue.sql - contains the queue dictionary information catrep.sql - run all sql scripts for replication option catrepc.sql - repcat tables, views, and sequences catrepm.sql - catalog script. for master replication packages catrepr.sql - catalog replication remove catreps.sql - installs pl/sql packages for snapshot functionality. catrls.sql - catalog views for row level security catrm.sql - packages for the dbms resource manager catrpc.sql - rpc procedural option catrule.sql - rules catalog creation catsnap.sql - data dictionary views for snapshots catsnmp.sql - creates an snmpagent role catspace.sql - catalog space management (remove with catspaced.sql) catsum.sql - data dictionary views for summary management catsvrmg.sql - create the views and tables required for server manager catblock.sql - creates the view blocking_locks, which shows which locks are blocking the system catnoaud.sql - removes the database audit trail created by cataudit.sql, including its data and views catnoprc.sql - removes data dictionary structures that were created by catprc.sql

关注
打赏
1653291990
查看更多评论
立即登录/注册

微信扫码登录

0.0401s