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


TABLE: SYS.SSCR_RES$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SSCR_RES$ NORMAL NONUNIQUE TablespaceSYSAUX ColumnSEQ#
Columns
Name Datatype Length Mandatory Comments
DB_NAME VARCHAR2 (4000)
INST_NAME VARCHAR2 (4000)
INST_ID NUMBER

SID NUMBER

SERIAL# NUMBER

USER_ID NUMBER

SCHEMA_ID NUMBER

SEQ# NUMBER

RMODE NUMBER

SCOPE NUMBER

FORMAT NUMBER

DIRECTORY VARCHAR2 (128)
LOCATOR RAW (64)
RESTORE_TIME TIMESTAMP(6) (11)
Query Text

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


SELECT DB_NAME
,      INST_NAME
,      INST_ID
,      SID
,      SERIAL#
,      USER_ID
,      SCHEMA_ID
,      SEQ#
,      RMODE
,      SCOPE
,      FORMAT
,      DIRECTORY
,      LOCATOR
,      RESTORE_TIME
FROM SYS.SSCR_RES$;

Dependencies

[top of page]

SYS.SSCR_RES$ does not reference any database object

SYS.SSCR_RES$ is referenced by following:

SchemaSYS
ViewDBA_SSCR_RESTORE