Processing method for Oracle 11g cannot export empty table with EXP
Execute the following SQL query in Plsql Dev:
Select ' '| | table_name| | ' allocate extent; ' from where num_rows=0
Then you can export the empty table in the oracle11g after you have copied the results and executed them.
Alter TableT_analy_item_item allocate extent;Alter TableT_analy_proce_inout_obj allocate extent;Alter TableT_analy_proce_proce allocate extent;Alter Tablet_data_busi_table allocate extent;Alter Tablet_edu_mooc_action allocate extent;Alter TableT_edu_mooc_action_member allocate extent;Alter TableT_edu_mooc_act_ref_cour allocate extent;Alter TableT_edu_mooc_course_media allocate extent;Alter TableT_edu_mooc_course_road allocate extent;Alter TableT_edu_mooc_credentials allocate extent;Alter TableT_inter_log allocate extent;Alter TableT_proc_busi_serv allocate extent;Alter Tablet_qldi_adapter_conf allocate extent;Alter TableT_qldi_adapter_defi allocate extent;Alter TableT_qldi_center allocate extent;Alter TableT_qldi_conf_val allocate extent;Alter TableT_qldi_dest_map allocate extent;Alter TableT_qldi_dest_map_prop allocate extent;Alter TableT_qldi_mess_auth allocate extent;Alter Tablet_qldi_mess_destination allocate extent;Alter TableT_qldi_mess_detail allocate extent;Alter TableT_qldi_mess_route allocate extent;Alter TableT_qldi_request allocate extent;Alter TableT_qldi_sys_jndi allocate extent;Alter TableT_qldi_timer allocate extent;Alter TableT_ql_data_log allocate extent;Alter TableT_service_log allocate extent;Alter TableT_service_user allocate extent;Alter TableT_service_web_pwd allocate extent;Alter TableT_sys_app_sso allocate extent;Alter TableT_sys_area_his allocate extent;Alter TableT_sys_busi_cate_ref allocate extent;Alter TableT_sys_file_type allocate extent;Alter TableT_sys_rule_def allocate extent;Alter TableT_sys_rule_ref allocate extent;Alter Tablet_sys_user_org allocate extent;Alter TableT_web_info_auth allocate extent;Alter TableT_web_info_reader allocate extent;Alter TableT_web_info_ref_info allocate extent;
Processing method for Oracle 11g cannot export empty table with EXP