DBA Data[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: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00240611
  1. ColumnTABID
Unique Key: SYS_C00240612
  1. ColumnSYS_NC0000800009$
Unique Key: SYS_C00240613
  1. ColumnSCHEMA_NAME
  2. ColumnTABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00240611 NORMAL UNIQUE TablespaceSYSTEM ColumnTABID
SYS_C00240612 NORMAL UNIQUE TablespaceSYSTEM ColumnPROPERTIES
SYS_C00240613 NORMAL UNIQUE TablespaceSYSTEM ColumnSCHEMA_NAME
ColumnTABLE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableDBFS_SFS$_VOL SYS_C00240622 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:

SchemaSYS
TYPEDBMS_DBFS_CONTENT_PROPERTIES_T
PL/SQL PackageSTANDARD - show dependent code
SYS.DBFS_SFS$_TAB is referenced by following:

SchemaSYS
Package BodyDBMS_DBFS_SFS - show dependent code
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code