11g 不能导出空表的方法
Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;



alter table MIAXIS_SEND_COACH_MESSAGE allocate extent;
alter table MIAXIS_SEND_CONTENT allocate extent;
alter table MIAXIS_SEND_EMBED_PROGRAM allocate extent;
alter table MIAXIS_SEND_MATCH_LIST allocate extent;
alter table MIAXIS_STUDENT_IDENTIFY_RECORD allocate extent;
alter table MIAXIS_STU_APPLY_GRAD_RECORD allocate extent;
alter table MIAXIS_STU_BILLS_SEAL_INFO allocate extent;
alter table MIAXIS_STU_CONSUME_INFO allocate extent;
alter table MIAXIS_STU_PAPER_INFO allocate extent;
alter table MIAXIS_STU_TRAIN_PRINT allocate extent;
alter table MIAXIS_TERMINAL_LOCAL_INFO allocate extent;
alter table MIAXIS_TERMINAL_ORDER allocate extent;
alter table MIAXIS_VIDEO_INFO allocate extent;
alter table MIAXIS_CLS_CLASS allocate extent;
alter table MIAXIS_CLS_CLASS_ROOM allocate extent;
alter table MIAXIS_CLS_ROOM allocate extent;
alter table MIAXIS_COACH_APPRAISE allocate extent;
alter table MIAXIS_COACH_CHECK_SINCERITY allocate extent;
alter table MIAXIS_COACH_DEDUCT_ELIMINATE allocate extent;
alter table MIAXIS_COACH_DEDUCT_MARK allocate extent;
alter table MIAXIS_COACH_RETRAIN_INFO allocate extent;
alter table MIAXIS_COACH_TRAINING_INFO allocate extent;
alter table MIAXIS_COACH_TRAINING_SUM_INFO allocate extent;
alter table MIAXIS_COACH_YEARLY_CHECK allocate extent;
alter table MIAXIS_COMPLAIN allocate extent;
alter table MIAXIS_CURRENT_ONLINE_INFO allocate extent;
alter table MIAXIS_GPS_INFO allocate extent;
alter table MIAXIS_GPS_TIME allocate extent;
alter table MIAXIS_INSPECTOR_INFO allocate extent;
alter table MIAXIS_LOCK_REL_CARD allocate extent;
alter table MIAXIS_REDUNDANCY_MODIFY allocate extent;
alter table DIC_CAR_JUDGE_RECORD allocate extent;
alter table DIC_EXAM_SUBJECT allocate extent;
alter table DIC_ORDER allocate extent;
alter table DIC_TRAIN_SUBJECT_PRICE allocate extent;
alter table MIAXIS_SCHOOL_SIGN allocate extent;
alter table MIAXIS_STUDENT_COACH allocate extent;
alter table PLSQL_PROFILER_DATA allocate extent;
alter table PLSQL_PROFILER_RUNS allocate extent;
alter table PLSQL_PROFILER_UNITS allocate extent;
alter table MIAXIS_CARD_VIRTUAL allocate extent;
alter table DIC_CAR_MAINTAIN allocate extent;
alter table DIC_LEAVE_MESSAGES allocate extent;
alter table DIC_MESSAGES_REPLY allocate extent;
alter table DIC_TRAIN_LINE allocate extent;
alter table D_AREA_CODE allocate extent;