Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_EXTERNAL_TABLES Description of the external tables accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the external table
2TABLE_NAMEVARCHAR230(null)NName of the external table
3TYPE_OWNERCHAR3(null)YOwner of the implementation type for the external table access driver
4TYPE_NAMEVARCHAR230(null)NName of the implementation type for the external table access driver
5DEFAULT_DIRECTORY_OWNERCHAR3(null)YOwner of the default directory for the external table
6DEFAULT_DIRECTORY_NAMEVARCHAR230(null)NName of the default directory for the external table
7REJECT_LIMITVARCHAR240(null)YReject limit for the external table
8ACCESS_TYPEVARCHAR27(null)YType of access parameters for the external table (CLOB/BLOB)
9ACCESS_PARAMETERSCLOB4000(null)YAccess parameters for the external table
10PROPERTYVARCHAR210(null)YProperty of the external table

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:32
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here