This discussion is archived
1 Reply Latest reply: Oct 15, 2013 6:51 PM by ittichai RSS

Unable to install APEX packaged application to user's default schema

user6057328 Newbie
Currently Being Moderated

Got 2 schemas in my workspace, AABB and APEX_DEMO. I've created a separate user, DemoAdmin with default to only APEX_DEMO, to install APEX packaged applications there.  However, when logged in as DemoAdmin, and trying to install any package, it always tries to use AABB, actually the first schema created in the workspace. Is this a bug, or is that supposedly the behavior?  Thanks for the inputs!!

  • 1. Re: Unable to install APEX packaged application to user's default schema
    ittichai Journeyer
    Currently Being Moderated

    When you tried to install a packaged application, which schema it said it will install to? The message should be displayed right before "Install Application".


    I tried to install the packaged application myself using an APEX account which has the SCHEMA2 as default. It still chose the SCHEMA1 by default. My take here is that this seems to be a limitation.

     

    Meeting Minutes
    Application Express Accounts
    WORKSPACE1
    SCHEMA1

     

    To work-around this, I install the packaged applications from the download files (fxxxx.sql) which can be found under APEX installation files (Downloads\apex_4.2.2_en\apex\core\packaged_apps). (Make sure choose the one compatible with your APEX version.) Just install it as you import an application file. During the import, you will have an option to choose which schema to import to (under Parsing Schema drop-down list).

     

    Hope it helps.

    Ittichai

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points