[Home] [Help]
[Dependency Information]
TABLE: SYS.DBFS_SFS$_TAB
Object Details
| Object Name: | DBFS_SFS$_TAB |
| Object Type: | TABLE |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
Storage Details
| Tablespace: | SYSTEM |
| PCT Free: | 10 |
| PCT Used: | 40 |
Primary Key: SYS_C00240041
-
TABID
Unique Key: SYS_C00240042
-
SYS_NC0000800009$
Unique Key: SYS_C00240043
-
SCHEMA_NAME
-
TABLE_NAME
Indexes
| Index |
Type |
Uniqueness |
Tablespace |
Column |
|
SYS_C00240041
|
NORMAL
|
UNIQUE
|
SYSTEM
|
TABID
|
|
SYS_C00240042
|
NORMAL
|
UNIQUE
|
SYSTEM
|
PROPERTIES
|
|
SYS_C00240043
|
NORMAL
|
UNIQUE
|
SYSTEM
|
SCHEMA_NAME
TABLE_NAME
|
Foreign Keys
| Table |
|
Foreign Table |
Foreign Key Column |
DBFS_SFS$_VOL
|
 |
DBFS_SFS$_TAB
|
DBFS_SFS$_VOL
TABID
|
Columns
| Name |
Datatype |
Length |
Mandatory |
Comments |
| TABID |
NUMBER |
|
Yes |
|
| SCHEMA_NAME |
VARCHAR2 |
(128) |
Yes |
|
| TABLE_NAME |
VARCHAR2 |
(128) |
Yes |
|
| PTABLE_NAME |
VARCHAR2 |
(128) |
|
|
| VERSION# |
VARCHAR2 |
(32) |
Yes |
|
| CREATED |
TIMESTAMP(6) |
(11) |
Yes |
|
| FORMATTED |
TIMESTAMP(6) |
(11) |
Yes |
|
| PROPERTIES |
DBMS_DBFS_CONTENT_PROPERTIES_T |
(16) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TABID
, SCHEMA_NAME
, TABLE_NAME
, PTABLE_NAME
, VERSION#
, CREATED
, FORMATTED
, PROPERTIES
FROM SYS.DBFS_SFS$_TAB;
Dependencies
[top of page]
SYS.DBFS_SFS$_TAB references the following:
-
SYS
-
DBMS_DBFS_CONTENT_PROPERTIES_T
-
STANDARD
- show dependent code
SYS.DBFS_SFS$_TAB is referenced by following:
-
SYS
-
DBMS_DBFS_SFS
- show dependent code
-
DBMS_DBFS_SFS_ADMIN
- show dependent code