VIEW: SYS.DBA_SSCR_RESTORE

Source

View Text - Preformatted

SELECT
  r.db_name,
  r.inst_name,
  r.inst_id,
  r.sid,
  r.serial#,
  u.name,
  s.name,
  r.seq#,
  decode(r.rmode,
         0, 'SESSION',
         1, 'GLOBAL',
         'UNKNOWN'),
  decode(r.scope,
         0, 'NONE',
         1, 'MINIMAL',
         2, 'TYPICAL',
         3, 'FULL',
         'UNKNOWN'),
  decode(r.format,
         0, 'NATIVE',
         1, 'UNIVERSAL'),
  r.directory,
  r.locator,
  r.restore_time
FROM sscr_res$ r, user$ u, user$ s
WHERE
  (r.user_id = u.user# AND r.schema_id = s.user#)

View Text - HTML Formatted

SELECT R.DB_NAME
, R.INST_NAME
, R.INST_ID
, R.SID
, R.SERIAL#
, U.NAME
, S.NAME
, R.SEQ#
, DECODE(R.RMODE
, 0
, 'SESSION'
, 1
, 'GLOBAL'
, 'UNKNOWN')
, DECODE(R.SCOPE
, 0
, 'NONE'
, 1
, 'MINIMAL'
, 2
, 'TYPICAL'
, 3
, 'FULL'
, 'UNKNOWN')
, DECODE(R.FORMAT
, 0
, 'NATIVE'
, 1
, 'UNIVERSAL')
, R.DIRECTORY
, R.LOCATOR
, R.RESTORE_TIME FROM SSCR_RES$ R
, USER$ U
, USER$ S WHERE (R.USER_ID = U.USER#
AND R.SCHEMA_ID = S.USER#)