how to get all schemas at oracle with owners and change them?

SQL> SELECT comp_id, comp_name, version, status, mrc_name, owner FROM schema_version_registry;
COMP_ID    COMP_NAME                      VERSION    STATUS      MRC_NAME   OWNER

———- —————————— ———- ———– ———- —————

BAM        BAM Services                   11.1.1.2.0 VALID       DEV        DEV_ORABAM MDS        Metadata Services              11.1.1.4.0 VALID       SYSMAN     SYSMAN_MDS ORASDPM    SDP Messaging                  11.1.1.2.0 VALID       DEV        DEV_ORASDPM SOAINFRA   SOA Infrastructure Services    11.1.1.4.0 VALID       DEV        DEV_SOAINFRA

1. Log in as SYSTEM to the database.
2. Run the following command:

UPDATE system.schema_version_registry$ SET    mrc_name = ‘DEV’, owner = ‘DEV_MDS’ WHERE  mrc_name = ‘SYSMAN’ AND owner = ‘SYSMAN_MDS’;

3. Rerun the “psa”.

Advertisements

About lorddisk

WebCenter Content, WebCenter Portal, WebCenter Sites,Weblogic, Identity and Access Management (IAM),SSO,OAM,OIM,OAAM,OUD, OPAM,OID, OVD ,Oracle API Gateway ,OBIEE,OEDQ, Oracle ADF, Oracle SOA,J2EE, CackePHP ,PHP,J2SE,J2EE,Spring,Hibernate,JQuery,CSS,Java Script ,Joomla,Drupal,Worpress
This entry was posted in ECM and tagged , . Bookmark the permalink.