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


TABLE: SYS.DBFS$_STORES

Object Details
Object Name: DBFS$_STORES
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00240021
  1. ColumnS_OWNER
  2. ColumnS_NAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00240021 NORMAL UNIQUE TablespaceSYSTEM ColumnS_OWNER
ColumnS_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableDBFS$_MOUNTS SYS_C00240027 DBFS$_STORES DBFS$_MOUNTS S_OWNER
DBFS$_MOUNTS S_NAME
Columns
Name Datatype Length Mandatory Comments
S_OWNER VARCHAR2 (128) Yes
S_NAME VARCHAR2 (32) Yes
P_NAME VARCHAR2 (32) Yes
P_PKG VARCHAR2 (128) Yes
CREATED TIMESTAMP(6) (11) Yes
Query Text

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


SELECT S_OWNER
,      S_NAME
,      P_NAME
,      P_PKG
,      CREATED
FROM SYS.DBFS$_STORES;

Dependencies

[top of page]

SYS.DBFS$_STORES does not reference any database object

SYS.DBFS$_STORES is referenced by following:

SchemaSYS
Package BodyDBMS_DBFS_CONTENT - show dependent code
Package BodyDBMS_DBFS_CONTENT_ADMIN - show dependent code
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code