Processing method for Oracle 11g cannot export empty table with EXP

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.