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

TABLE: SYS.DBFS_SFS$_FSTP

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: SYS_C00240094
  1. ColumnVOLID
  2. ColumnSTD_GUID
  3. ColumnCSNAP#
  4. ColumnPROPNAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00240094 NORMAL UNIQUE TablespaceSYSTEM ColumnVOLID
ColumnSTD_GUID
ColumnCSNAP#
ColumnPROPNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
DBFS_SFS$_FSTP SYS_C00240095 TableDBFS_SFS$_FST DBFS_SFS$_FSTP VOLID
DBFS_SFS$_FSTP STD_GUID
DBFS_SFS$_FSTP CSNAP#
Columns
Name Datatype Length Mandatory Comments
VOLID NUMBER
Yes
CSNAP# NUMBER
Yes
LSNAP# NUMBER

STD_GUID NUMBER
Yes
PROPNAME VARCHAR2 (32) Yes
PROPVALUE VARCHAR2 (1024) Yes
TYPECODE NUMBER
Yes
Query Text

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


SELECT VOLID
,      CSNAP#
,      LSNAP#
,      STD_GUID
,      PROPNAME
,      PROPVALUE
,      TYPECODE
FROM SYS.DBFS_SFS$_FSTP;

Dependencies

[top of page]

SYS.DBFS_SFS$_FSTP does not reference any database object

SYS.DBFS_SFS$_FSTP is referenced by following:

SchemaSYS
Package BodyDBMS_DBFS_SFS - show dependent code