3 Replies Latest reply: Mar 12, 2013 12:12 AM by Denes Kubicek RSS

    Exported and Imported an APEX app but am missing Apex_Access_Control table

    John K.-Oracle
      Hi All -
      I exported an application and imported it onto a different db.

      When I run the imported app I get this error:
      ora_sqlerrm: ORA-06550: line 11, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 10, column 14: PL/SQL: SQL Statement ignored ORA-06550: line 14, column 20: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 14, column 6: PL/SQL: Statement ignored ORA-06550: line 15, column 16: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 15, column 6: PL/SQL: Statement ignored ORA-06550: line 23, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 2
      component.type: APEX_APPLICATION_AUTHORIZATION
      component.id: 37708510405766468
      component.name: access control - edit
      error_backtrace:
      
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 904
      ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 588
      ORA-06512: at "APEX_040100.WWV_FLOW_AUTHORIZATION", line 69
      ORA-06512: at "APEX_040100.WWV_FLOW_AUTHORIZATION", line 147
      ORA-06512: at "APEX_040100.WWV_FLOW_PLUGIN_ENGINE", line 2089
      ORA-06512: at "APEX_040100.WWV_FLOW_AUTHORIZATION", line 378
      I noticed that the new db to which I imported the app is missing the tables Apex_Access_Control & Apex_Access_Setup.

      Can I just copy these tables and the data over to the new db or did I miss a step during the export/import?

      Any advice is much appreciated!