This content has been marked as final. Show 3 replies
You didn't mention what version of APEX you are using. Their was an issue in 4.1 in the export file where the owner wasn't being updated:
Try modifying the p_owner =>'PAUL' line in your export file and change it to the name of the schema your importing it into.
wwv_flow_api.create_load_table( p_id =>3570143708960669327+ wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_name =>'Load Employees', p_owner =>'PAUL', p_table_name =>'EMP', p_unique_column_1 =>'EMPNO', p_is_uk1_case_sensitive =>'N', p_unique_column_2 =>'', p_is_uk2_case_sensitive =>'N', p_unique_column_3 =>'', p_is_uk3_case_sensitive =>'N', p_wizard_page_ids =>'', p_comments =>'');