Forum Stats

  • 3,757,058 Users
  • 2,251,192 Discussions
  • 7,869,716 Comments

Discussions

URG : How can I force APEX to use specific schema : APEX_040100 or assign workspaces from another sc

egudai-Oracle
egudai-Oracle Member Posts: 46 Employee
edited Jan 13, 2016 5:00AM in APEX Discussions

Hello All,

Here is the scenario :

  1. My Computer crashed. had to get back from full export (expdp 11.2.x to impdp 12c). successfully done.
  2. Configured ORDS bla bla ... can access to apex admin.
  3. Problem is : DON'T SEE my apex workspaces IN Apex admin interface (only the INTERNAL workspace).
  4. After investigation it it seems that APEX (after the upgrade) is somehow configured / run with : APEX_040200 schema and not

APEX_040100 (as I upgraded versions of apex in the old database).


5. If I run the following :

Alter session set current_schema = APEX_040100; 

select short_name, display_name 

from wwv_flow_companies 

where source_identifier is not null;


I can SEE all my beloved workspaces.

6. my questions :

   a. How can I force APEX to use specific schema : APEX_040100 instead of APEX_040200 ?

   b. Or Is there any other alternative to assign those workspaces in current environment ?


Regards

Etay G

Best Answer

  • egudai-Oracle
    egudai-Oracle Member Posts: 46 Employee
    edited Jan 13, 2016 5:00AM Accepted Answer

    Hello Brad,

    Thank you for your answer. Appreciated.

    • Yet, as I had a bit corrupted Apex environment after FULL Database import (impdp), this revoking method (above) failed few times for me.

    • Here is what I did (solved the problem):

    • RemovedAPEX_040200Apex 4.2 installation).

    • Only version left in DB is APEX_040100

    • Then, installed version 5.0.3 and It worked!
      Most important, After installing APEX, all workspaces, users, etc were automatically resided correctly in  APEX.

    • I think that if you have only 1 version of corrupted apex in DB. It should work as well. Yet, remove schema using the above script (check version) with caution (after backup etc).

    Regards,

    Etay G

Answers

This discussion has been closed.