[bbk5334] 第115集 -第14章 - 数据库空间管理 04

检查数据库中存在的外部表,外部文件:

SQL> show user
USER is "SYS"
SQL> declare
  2   external boolean;
  3  begin
  4   external := dbms_tdb.check_external;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> set serverout on
SQL> /
The following external tables exist in the database:
SH.SALES_TRANSACTIONS_EXT, TEST.EXT_EMP1, TEST.EXT_EMP2
The following directories exist in the database:
SYS.TEST_DIR, SYS.SUBDIR, SYS.SS_OE_XMLDIR, SYS.MEDIA_DIR, SYS.LOG_FILE_DIR,
SYS.DATA_FILE_DIR, SYS.XMLDIR, SYS.DATA_PUMP_DIR, SYS.ORACLE_OCM_CONFIG_DIR
The following BFILEs exist in the database:
PM.PRINT_MEDIA

PL/SQL procedure successfully completed.

/*

  数据库移植项目案例

*/ 

 

 

 

 

 

posted @ 2013-06-09 20:43  ArcerZhang  阅读(193)  评论(0编辑  收藏  举报