Query to get RCU version

1.To get the RCU version of the schemas installed.
SQL>SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY

Result
————————————————————————-
DEVR2_BIPLATFORM 11.1.1.6.0 VALID N
DEV3_BIPLATFORM 11.1.1.6.0 VALID N
DEV_BIPLATFORM 11.1.1.6.0 VALID N
DEV3_IAU 11.1.1.6.0 VALID N
DEVR2_IAU 11.1.1.6.0 VALID N
DEVR2_MDS 11.1.1.6.0 VALID N

About Sudhir

Sudhir Tadi works as a Senior Technology Sales Consultant for EMEA-Presales Center at Oracle.The opinions expressed here are purely his own; nobody else necessarily agrees with them.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a comment