APEX

Hello all.

I wanted to have another environment for testing modifications to my application, environment that has is on another machine. So on that machine I've installed a new database (exactly the same as on the original machine) and a new application express (exactly the same). Then i've exported the workspace, i've imported it to the new environment (on apex_admin mode). Next step was to get into my application's workspace and export it, Then I've imported my app to the new workspace just created. With SQL Developer i've exported all the tables and then I've created them in the new machine.

All with no errors.
Then I've tried to run my app. First thing i notice is that it doesn't ask for a user and password. That mean i didn't know how to import users?

The errors i get are:

Error processing authorization.
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 18: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 14, column 4: PL/SQL: Statement ignored ORA-06550: line 15, column 14: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 15, column 4: PL/SQL: Statement ignored ORA-06550: line 23, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: APEX.AUTHORIZATION.UNHANDLED_ERROR
ora_sqlcode: -6550
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 18: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 14, column 4: PL/SQL: Statement ignored ORA-06550: line 15, column 14: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 15, column 4: PL/SQL: Statement ignored ORA-06550: line 23, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line
component.type: APEX_APPLICATION_AUTHORIZATION
component.id: 11672738986893340
component.name: access control - view
error_backtrace:
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 773
ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 80
ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 160
ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1922
ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 411

Please help me understand what i didn't do or what I do wrong.

Thank you.

Best regards,
Gabriel