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

TABLE: SYS.DBFS_SFS$_FS

Object Details
Object Name: DBFS_SFS$_FS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: SYS_C00240067
  1. ColumnSTORE_OWNER
  2. ColumnSTORE_NAME
Unique Key: SYS_C00240068
  1. ColumnSTORE_OWNER
  2. ColumnTABID
  3. ColumnVOLID
  4. ColumnSNAP#
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00240067 NORMAL UNIQUE TablespaceSYSTEM ColumnSTORE_OWNER
ColumnSTORE_NAME
SYS_C00240068 NORMAL UNIQUE TablespaceSYSTEM ColumnSTORE_OWNER
ColumnTABID
ColumnVOLID
ColumnSNAP#
Foreign Keys
Table
Foreign Table Foreign Key Column
DBFS_SFS$_FS SYS_C00240069 TableDBFS_SFS$_VOL DBFS_SFS$_FS TABID
DBFS_SFS$_FS VOLID
Columns
Name Datatype Length Mandatory Comments
STORE_OWNER VARCHAR2 (128) Yes
STORE_NAME VARCHAR2 (32) Yes
TABID NUMBER
Yes
VOLID NUMBER
Yes
SNAP# NUMBER

CREATED TIMESTAMP(6) (11) Yes
Query Text

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


SELECT STORE_OWNER
,      STORE_NAME
,      TABID
,      VOLID
,      SNAP#
,      CREATED
FROM SYS.DBFS_SFS$_FS;

Dependencies

[top of page]

SYS.DBFS_SFS$_FS does not reference any database object

SYS.DBFS_SFS$_FS is referenced by following:

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