DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_EXTERNAL_LOCATIONS

Object Details
Object Name: CDB_EXTERNAL_LOCATIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the external tables locations accessible to the DBA in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the external table location
TABLE_NAME VARCHAR2 (30) Yes Name of the corresponding external table
LOCATION VARCHAR2 (4000)
External table location
DIRECTORY_OWNER CHAR (3)
Owner of the directory containing the external table location
DIRECTORY_NAME VARCHAR2 (128)
Name of the directory containing the location
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      TABLE_NAME
,      LOCATION
,      DIRECTORY_OWNER
,      DIRECTORY_NAME
,      CON_ID
FROM SYS.CDB_EXTERNAL_LOCATIONS;

Dependencies

[top of page]

SYS.CDB_EXTERNAL_LOCATIONS does not reference any database object

SYS.CDB_EXTERNAL_LOCATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_EXTERNAL_LOCATIONS