DBA_external_tables
http://radiocom.kunsan.ac.kr
데이터베이스에 만들어진 외부 테이블에 대한 정보를 제공한다. 
【예제】
SQL> desc dba_external_tables;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 TYPE_OWNER                                         CHAR(3)
 TYPE_NAME                                 NOT NULL VARCHAR2(30)
 DEFAULT_DIRECTORY_OWNER                            CHAR(3)
 DEFAULT_DIRECTORY_NAME                    NOT NULL VARCHAR2(30)
 REJECT_LIMIT                                       VARCHAR2(40)
 ACCESS_TYPE                                        VARCHAR2(7)
 ACCESS_PARAMETERS                                  VARCHAR2(4000)
 PROPERTY                                           VARCHAR2(10)
 
SQL> select count(*) from dba_external_tables;
 
  COUNT(*)
----------
         1
 
SQL> select * from dba_external_tables;



OWNERSH

TABLE_NAMESALES_TRANSACTIONS_EXT

TYPSYS

TYPE_NAMEORACLE_LOADER

DEFSYS

DEFAULT_DIRECTORY_NAMEDATA_FILE_DIR

REJECT_LIMIT100

ACCESS_CLOB

ACCESS_PARAMETERS

RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE log_file_dir:'ext_1v3.bad'
    LOGFILE log_file_dir:'ext_1v3.log'
    FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '^' LDRTRIM
    ( PROD_ID         ,
      CUST_ID         ,
      TIME_ID         DATE(10) "YYYY-MM-DD",
      CHANNEL_ID      ,
      PROMO_ID        ,
      QUANTITY_SOLD   ,
      AMOUNT_SOLD     ,
      UNIT_COST       ,
      UNIT_PRICE
    )

                                                                             
PROPERTYALL