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

TABLE: SYS.DBFS_SFS$_SNAP

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00240060
  1. ColumnTABID
  2. ColumnVOLID
  3. ColumnSNAP#
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00240060 NORMAL UNIQUE TablespaceSYSTEM ColumnTABID
ColumnVOLID
ColumnSNAP#
Foreign Keys
Table
Foreign Table Foreign Key Column
DBFS_SFS$_SNAP SYS_C00240061 TableDBFS_SFS$_VOL DBFS_SFS$_SNAP TABID
DBFS_SFS$_SNAP VOLID
Columns
Name Datatype Length Mandatory Comments
TABID NUMBER
Yes
VOLID NUMBER
Yes
SNAP# NUMBER
Yes
SNAPNAME VARCHAR2 (128) Yes
CREATED TIMESTAMP(6) (11) Yes
DELETED NUMBER
Yes
Query Text

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


SELECT TABID
,      VOLID
,      SNAP#
,      SNAPNAME
,      CREATED
,      DELETED
FROM SYS.DBFS_SFS$_SNAP;

Dependencies

[top of page]

SYS.DBFS_SFS$_SNAP does not reference any database object

SYS.DBFS_SFS$_SNAP is referenced by following:

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