Script to validate Object Status
SELECT
OWNER
,OBJECT_NAME
,OBJECT_TYPE
,case STATUS
when 'INVALID' then '<html><font size="4" color="red">'||STATUS
when 'VALID' then '<html><font size="4" color="green">'||STATUS
end
STATUS
,CREATED
,LAST_DDL_TIME
,TIMESTAMP
FROM SYS.DBA_OBJECTS
WHERE OBJECT_NAME = <Object Name>
SELECT
OWNER
,OBJECT_NAME
,OBJECT_TYPE
,case STATUS
when 'INVALID' then '<html><font size="4" color="red">'||STATUS
when 'VALID' then '<html><font size="4" color="green">'||STATUS
end
STATUS
,CREATED
,LAST_DDL_TIME
,TIMESTAMP
FROM SYS.DBA_OBJECTS
WHERE OBJECT_NAME = <Object Name>
No comments:
Post a Comment