eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.GV_$IR_REPAIR

Object Details

Object Name:	GV_$IR_REPAIR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
REPAIR_ID	NUMBER
ADVISE_ID	NUMBER
SUMMARY	VARCHAR2	(32)
RANK	NUMBER
TIME_DETECTED	DATE
EXECUTED	DATE
ESTIMATED_DATA_LOSS	VARCHAR2	(20)
DETAILED_DESCRIPTION	VARCHAR2	(1024)
REPAIR_SCRIPT	VARCHAR2	(512)
ESTIMATED_REPAIR_TIME	NUMBER
ACTUAL_REPAIR_TIME	NUMBER
STATUS	VARCHAR2	(7)
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      REPAIR_ID
,      ADVISE_ID
,      SUMMARY
,      RANK
,      TIME_DETECTED
,      EXECUTED
,      ESTIMATED_DATA_LOSS
,      DETAILED_DESCRIPTION
,      REPAIR_SCRIPT
,      ESTIMATED_REPAIR_TIME
,      ACTUAL_REPAIR_TIME
,      STATUS
,      CON_ID
FROM SYS.GV_$IR_REPAIR;

Dependencies

[top of page]

SYS.GV_$IR_REPAIR references the following:

SYS.GV_$IR_REPAIR is referenced by following:

PUBLIC: GV$IR_REPAIR