DBA Data[Home] [Help]

VIEW: SYS.DBMS_UPG_CURRENT_STATUS

Source

View Text - Preformatted

SELECT status, source_schema, target_schema, message,
         to_char(st_time, 'mon yyyy: hh:mi:ss'),
         to_char(en_time, 'mon yyyy: hh:mi:ss')
  FROM dbms_upg_status$
  WHERE sequence# = (SELECT max(sequence#) FROM dbms_upg_status$)
View Text - HTML Formatted

SELECT STATUS
, SOURCE_SCHEMA
, TARGET_SCHEMA
, MESSAGE
, TO_CHAR(ST_TIME
, 'MON YYYY: HH:MI:SS')
, TO_CHAR(EN_TIME
, 'MON YYYY: HH:MI:SS')
FROM DBMS_UPG_STATUS$
WHERE SEQUENCE# = (SELECT MAX(SEQUENCE#)
FROM DBMS_UPG_STATUS$)