[Home] [Help] [Dependency Information]
Object Name: | DBFS$_MOUNTS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IS_DBFS$_MOUNTS | FUNCTION-BASED NORMAL | UNIQUE | SYSTEM | DECODE("S_MOUNT",NULL,"S_OWNER",NULL) |
SYS_C00240595 | NORMAL | UNIQUE | SYSTEM | S_PROPS |
SYS_C00240596 | NORMAL | UNIQUE | SYSTEM |
S_OWNER
S_MOUNT |
Table | |
Foreign Table | Foreign Key Column | DBFS$_MOUNTS | DBFS$_STORES |
DBFS$_MOUNTS
S_OWNER
DBFS$_MOUNTS S_NAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
S_OWNER | VARCHAR2 | (128) | Yes | |
S_NAME | VARCHAR2 | (32) | Yes | |
S_MOUNT | VARCHAR2 | (32) | ||
CREATED | TIMESTAMP(6) | (11) | Yes | |
S_PROPS | DBMS_DBFS_CONTENT_PROPERTIES_T | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT S_OWNER
, S_NAME
, S_MOUNT
, CREATED
, S_PROPS
FROM SYS.DBFS$_MOUNTS;
|
|
|