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!