[Home] [Help] [Dependency Information]

TABLE: SYS.DBFS$_MOUNTS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: SYS_C00240025

1. SYS_NC0000500006$

Unique Key: SYS_C00240026

1. S_OWNER
2. S_MOUNT

Indexes

Index	Type	Uniqueness	Tablespace	Column
IS_DBFS$_MOUNTS	FUNCTION-BASED NORMAL	UNIQUE	SYSTEM	DECODE("S_MOUNT",NULL,"S_OWNER",NULL)
SYS_C00240025	NORMAL	UNIQUE	SYSTEM	S_PROPS
SYS_C00240026	NORMAL	UNIQUE	SYSTEM	S_OWNER S_MOUNT

Foreign Keys

Table		Foreign Table	Foreign Key Column
DBFS$_MOUNTS		DBFS$_STORES	DBFS$_MOUNTS S_OWNER DBFS$_MOUNTS S_NAME

Columns

Query Text

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

SELECT S_OWNER
,      S_NAME
,      S_MOUNT
,      CREATED
,      S_PROPS
FROM SYS.DBFS$_MOUNTS;

Dependencies

[top of page]

SYS

DBMS_DBFS_CONTENT_PROPERTIES_T

STANDARD - show dependent code

SYS

DBMS_DBFS_CONTENT - show dependent code

DBMS_DBFS_CONTENT_ADMIN - show dependent code

DBMS_DBFS_SFS_ADMIN - show dependent code