oracle数据库指定表名迁移数据步骤
oracle数据库指定表名迁移数据步骤
导数ERPTESTDB-aidba
#196.168.1.105 生产环境导出命令：
exp aidba/paassdfedsd file=aidba_196.168.1.105_20250221_tables.dmp log=aidba_196.168.1.105_20250221_tables.log buffer=10240000 grants=y rows=y statistics=none tables=HYY_SETTLE_TIMESHEET,HYY_CO_ORDER_TIMESHEET,HYY_PROJECTS_ALL_HIS,HYY_OA_INFO,HYY_HUMAN_ORDER_DETAIL_HIS,T1_BACKUP_EXPORT_STAGING,PRJ_USER_ITF,TIME_INFO,T1_PRJ_USER_ITF,HYY_CO_EXPENSE_SETTLEMENT,HYY_SUBMIT_EXPENSE_HIS,HYY_ORDER_APPLY_HIS,HYY_ORDER_TERMINATION_HIS,HYY_SAVE_EXPENSE_HIS,HYY_COMPUTE_REQUEST,BACKUP_MAN_HOUR_EXPORT_RESULT,HYY_CO_APPLICATION_PROCESS,HYY_CO_APPLICATION_PROCESS_HIS,HYY_STAFF_SYNC_HR_RECORD_HIS,TEMP_XXAI_PA_POM_COST_TS_T,HYY_EXPENSE_PROVISION_HIS,HYY_RESOURCE_POOL_HIS,HYYDC_ORDER_HUMAN_INFO,HYY_APP_APPLY_HIS,HYY_HUMAN_APP_DETAIL_HIS,HYY_RESOURCE_POOL_FORCAST,HYY_ORDER_TERMINATION,T1_BACKUP_EXPORT_RESULT,PRJ_USER_ITF_ALL,HYY_MANUSCRIPT_VERSION,HYY_EXPENSE_PROVISION,TEMP_HYY_EXPENSE_PROVISION_830,HYYDC_ORDER_APPLY,HYY_CO_APP_ATTACHMENT,HYY_VOUCHER_LATEMEAL_ITEM,AITS_EMPLOYEE_INFO_HISTORY,HYY_CHANGE_ORDER_APPLY_HIS,HYY_VOLUNTARILY_RECORD,HYY_SUBMIT_EXPENSE,HYYDC_ORDER_SAVE_EXPENSE,HYY_STAFF_SYNC_HR_RECORD,HYY_HUMAN_ORDER_DETAIL,HYYDC_ORDER_SUBMIT_EXPENSE,HYY_SAVE_EXPENSE,HYYDC_PAY_APPLY,AL_DATA_PROJECTS_ALL,AITS_PROJECT_TASKS_UPDATE,HYY_HUMAN_APP_DETAIL,PRJ_USER_ITF_ALL_HIS,AP_INTERFACE,HYY_KPI_SETTING_STAFF_SCORE,HYY_CHANGE_ORDER_APPLY,HYY_VOUCHER_TRAFFIC_ITEM,HYY_PERSON_CHANGE_APPLY_HIS,HYY_COSTRATE_RECORD,RETURN_AP,HYY_MAN_HOUR_EXPORT_STAGING,HYY_PLAN_APPLY_HIS,HYY_HUMAN_MONTHLY_EXPENSE,HYY_CERTIFICATION_EMAIL_LOG,HYY_HUMAN_ORDER_DETAIL_TEST,HYY_ORDER_APPLY,AII_EMPLOYEE_INFO_CUR_V,HYY_AD_SYNC_RECORD_HIS,HYY_PERSON_SETTLE_STAFF,HYY_ALL_FORCAST_TABLE,HYY_SDP_LABOR,AITS_PROJECT_TASKS_UPDATE_TEMP,HYY_ORDER_ACCOUNT_DETAIL,AII_EMPLOYEE_COSTCENTER_ALL_DP,HYY_RESUME_PROJECT_EXPERIENCE,HYY_SYNC_STAFF_HIS,HYY_RESUME_FILE,HYY_LEAVE_FILE,T1_HYY_EXPORT_STAGING,TEMP0_MAN_HOUR_EXPORT_STAGING,HYY_KPI_SETTING_STAFF,PRJ_USER_ITF_HIS,HYY_APPROVAL_PERSON_HIS,HYY_AD_SYNC_RECORD,HYY_APP_APPLY,HYY_APPROVE_PROCESS_APPLY,HYY_ORDER_BACKFILL_PAY,HYY_PROJECT_APP_DETAIL_HIS,HYY_PROJECTS_ALL,HYY_CLAIM_VOUCHER_APPLY,HYY_EVALUATION_RESUME,HYY_TECHNICAL_STAFF,HYY_RECRUIT_INTERVIEW_RESULT,HYY_STAFF_PERCENT_COST,PRJ_PFM_MONTH_ITF,HYY_VOUCHER_APPLY_FLOW,HYY_PERSON_CHANGE_APPLY,HYY_PROJECT_APP_DETAIL,TEMP_EMPLOYEE,HYYDC_ORDER_SPLIT_RANGE,HYY_TECH_MONTHLY_EXPENSE,TB_ITEM_BUDGETVERSION,PRJ_USER_ITF_TEMP,HYYDC_ORDER_HUMAN_NUM,TBDATAOPERATE_LOG,HYY_SDP_PROJECT,HYY_AD_LOGS,HYY_NO_PROJECT_APP_DETAIL_HIS,HYY_OVERTIME_SHEET_REFRESH,PA_INTERFACE,HYY_PROVISION_APP_RELATION,HYY_BU_AREA_PERMISSION,HYY_RELEASE_LOG,HYY_RESUME_SKILLS,HYY_RESUME_WORK_EXPERIENCE,HYY_OVERTIME_APPLY_DETAIL,HYY_OVERTIME_DISTRIBUTION,HYY_OVERTIME_TEMPLATE,HYY_WRITEOFF_MONTHLY_EXPENSE,OSBC_BUSINESS_INFORMATION,HYY_OVERTIME_APPLY,HYY_PERSON_CHANGE_DETAIL,HYY_PLAN_APPLY,HYY_SCORE_ENTER,HYY_RECRUIT_DEMAND,TEST_SJ,HYY_OVERTIME_IMPORT_INFO,HYY_PERSON_CHANGE_DETAIL_HIS,HYYDC_ORDER_RANGE,TB_ITEM_MILESTONE,HYY_PERSON_CHANGE_RELEASE_LOG,HYY_RELEASE_OVERTIME_DETAIL,HYY_RECRUIT_TASK_RESUME_RECORD,HYY_SDP_THIS_MONTH_LABOR,RETURN_PA,HYY_ORDER_SIGNDATE_BACKFILL,HYY_HUMAN_PLAN_DETAIL,HYY_NO_PROJECT_APP_DETAIL,HYY_ZB_MONTHLY_EXPENSE,HYY_STAFF_SCORE,HYY_CERTIFICATION_STAFF_RECORD,HYY_RECRUIT_TASK_RESUME,HYY_VOUCHER_APPLY_WRITEOFF,HYY_TBDATAOPERATE_LOG,HYY_TEMP_SETTLE_TIMESHEET,HYY_SENDMAIL_SIZE,HYY_DAY_LOGIN,HYY_APPROVE_RESUME,HYY_ENTRY_CLERK_STAFF_DETALL,HYY_DIRECT_MANAGER,HYY_VOUCHER_APPLY_RELATION,HYY_PROVISION_ACCEPT,HYY_ORDERLIST_INTERFACE,HYY_ORDERLIST_ALL,HYY_RECRUIT_TASK_OFFICE_FLOW,HYY_RECRUIT_RESUME_OPT,HYY_RESUME_EDU_EXPERIENCE,HYY_POM_PROJECT_TIMESHEET,HYY_STAFF_PERSON,HYY_PUSH_RESUME_OPT,HYY_KPI_FLOW_LOG,HYY_KPI_SETTING_STAFF_LEVEL,HYY_AUDITION_RESUME_FLOW,HYY_RECRUIT_RESUME,HYY_APP_ORDER_MONEY_INFO,HYY_APPROVAL_PERSON,AITS_PROJECT_INFORMATION_RD,HYY_ORDER_TERMINATION_ADD_HIS,TEMP_PROJECT_TASKS,HYY_ENTRY_CLERK_APPLY,HYY_TECHNICAL_COOPERATION_HIS,TEMP_EXPENSE_SETTLEMENT,HYY_RECRUIT_TASK,HYY_COOP_COST_DEDUCTION_DETAIL,TMP_AII_ORG_COSTCENTER_CUR_V,HYY_STAFF_EDU_INFO,TEMP_HYY_STAFF_EDU_INFO,HYY_CERTIFICATION_TEST_RECORD,TEMP_HYY_HUMAN_APP_DETAIL,PA_PROJECTS_ALL_CURRENCY,HYY_SDP_LABOR_BUDGET,HYY_EXAM_MAKEUP,HYY_KPI_FLOW_STEP,HYY_MODIFY_ORDER_RECORD,HYY_RESOURCE_POOL_FLOW,HYY_STAFF_BANKCARD_REVIEW,HYY_COMMON_PRICE_APPLY,HYY_MANUSCRIPT_CC,HYY_CHANGE_LOG,TEMP_FML,HYY_VOUCHER_TRAVEL_ITEM,HYY_SELECTED_RESUME_NEW,HYY_ORDER_TERMINATION_ADD,TEMP_ZW_ORDER,HYY_SCHOOL_INFO,TEMP_PERSON_CID,HYY_RESULT_ENTITY,HYY_MANAGERS_POOL,HYY_SELECTED_RESUME,ERP_INTERFACE_DAILY,HYY_KPI_SETTING,HYY_INPUT_FORCAST_DETAIL_HIS,HYY_PURCHASE_MACHINE,TEMP_STAFF_BANK_INFO,HYY_SDP_THIS_MONTH_LABOR_DAILY,HYY_SBU_LARGEAREA,AITS_PROJECT_MANAGERS_RD,HYY_CO_BOC_TIMESHEET,TEMP_CARD_ESTABLISHMENT_ALL,HYY_SBU_LARGEAREA_HIS,TEMP_CARD_ESTABLISHMENT,HYY_ZB_SAVE_EXPENSE,HYY_SENDMAIL_SIZE_ZZ,HYY_PLAN_APP_MONEY_INFO,HYY_TEMP_AIAD_ACCOUNT,HYY_DMP_SYNC_HOLIDAY,HYY_AD_TEMP_CHECK,HYY_COOP_COST_RETURN_COMP,TEST_CHENLIU,HYY_COOP_COST_RETURN_DETAIL,HYY_PROJECT_INFORMATION,NEWMIS_CCOWNER,HYY_APPROVE_PROCESS_STEP,HYY_TECHNICAL_COOPERATION,HYY_TECH_SRV_PLAN_DETAIL,HYY_TECHNICAL_STAFF_TEMP,HYY_HUMAN_PLAN_DETAIL_HIS,HYY_EXAM_MAKEUP_PROCESS,HYY_KPI_WEIGHT,HYY_BOC_EMPLOYEE_INFO,PRJ_PFM_MONTH_ITF_TEMP,TMP_OOA_EMAIL,HYY_PROJECT_MANAGERS,HYY_APPLYER_AGENT,HYY_SUSPEND_APPLICATION,HYY_RESOURCE_POOL,HYY_INPUT_FORCAST_HIS,HYY_ZB_ORDER,HYY_VOUCHER_INVOICE,HYY_PROBATION_INFO,HYY_COOP_COST_RETURN_DETAIL_2A,HYY_BANK_INFO,HYY_PURCHASE_MACHINE_DETAIL,HYY_LOCK_USER,HYY_TIMESHEET_SESSION_DATE,TEMP_IDENTIFICATION,HYY_ZZ_EMAIL_HIS,HYY_APPROVER_AGENT,TEMP_PERSON,HYY_PERSON_CHANGE_INFO_DETAIL,HYY_PERSON_CHANGE_INFO_APPLY,TEMP_TIMESHEE,HYY_MAN_HOUR_EXPORT_LOG,HYY_TEMP_TECHNICAL_STAFF,HYY_STAFF_SALARY,HYY_BUSINESS_MANAGER,HYY_BOC_ORDER_APPLY,HYY_BASEDATA_VINDICATE,HYY_OA_TASKTRACT,HYY_RESOURCE_POOL_FILLRATE,HYY_TIMESHEET_APPROVER_AGENT,PRJ_USER_ITF_ERR,TEST_CL_DATA,HYY_ROLE_MENU,TEST_ZKP,HYY_APPROVE_PROCESS_CONFIG,HYY_CO_EXPENSE_SETTLEMENT_HIS,HYY_MANUSCRIPT_STEP,HYY_MANUSCRIPT_STEP_LOG,HYY_ORDER_CODE,HYY_EMAIL_TEMPLETE,HYY_INPUT_FORCAST_DETAIL,HYY_LARGEAREA,HYY_HUMAN_BOC_ORDER_DETAIL,HYY_RESUME_CERTIFICATE,HYY_AUDITION_FLOW_BACK_LOG,ORDER_DETAIL,T1_HYY_EXPORT_LOG,TB_ITEM_BIND_INFO,HYY_TIMESHEET_SESSION,HYY_TIMESHEET_ROLE_MENU,HYY_TIMESHEET_MENU,HYY_TIMESHEET_BOC_APPROVER,HYY_TIMESHEET_AUTH_CONFIG,SDP_MIXED_PROJECT_FINAL,QUERY_PERMISSION_CONFIG,TEMP_HYY_TECHNICAL_STAFF,YJY_TEMP,T_LYW,HYY_SDP_AREA_MAPPING,AL_DATA_AREA_S,HYY_MOVE_STAFF,AITS_TIMESHEET_SESSION_DATE,AITS_TIMESHEET_SESSION,HYY_APPROVAL_ROLE,HYY_APPLICATION_CODE,HYY_APPROVE_ROLE_MAX_MONEY,AII_REGION_V,HYY_CORPORATE_VIOLATIONS,HYY_PAYMENT_REPORT,HYY_LEVEL_MAPPING,HYY_CO_APP_BUSINESS_TYPE,HYY_FAIL_POOL,HYY_EX_OPEN_CLOSE_TIME_HIS,HYY_TIME_WINDOW,HYY_TEMP_PLAN_FORCAST,HYY_TECH_SRV_PLAN_DETAIL_HIS,HYY_BG_ASSIGNER,HYY_SIGN_FOCUS,HYY_SETTLE_TIMESHEET_HIS,HYY_MANUSCRIPT_FLOW,HYY_MANUSCRIPT_CANCEL,HYY_OLD_PROJECT_POOL,HYY_EX_OPEN_CLOSE_TIME,HYY_DOCUMENT_MANAGE,HYY_DEV_CONSTANT,HYY_INPUT_FORCAST,HYY_HUMAN_ORDER_DETAIL_TMP,HYY_MENU,PROJECTS_RELATION_CORRESPOND,HYY_VALID_COMPANY,HYY_VALID_BU,HYY_USER_ROLE,HYY_TIMESHEET_USER_ROLE,HYY_TIMESHEET_SESSION_STATUS,AII_BG_V,HYY_BLACK_RESUME,HYY_COST_COEFFICIENT,HYY_RECRUIT_CONSULTANTS,HYY_RECRUIT_ENTRY_PROGRESS,HYY_APPROVE_AGENT_TEMP_D,HYY_APPROVE_AGENT_TEMP,HYY_APP_MONEY_CHANGE_FLOW,TEMP_PA_PROJECT,HYY_MAN_HOUR_EXPORT_RECORD,TEMP_WX,TMP_HYY_CO_ORDER_TIMESHEET,HYY_BLACKLIST,HYY_KPI_QUARTER,HYY_KPI_TARGET,HYY_KPI_TEMPLATE_TARGET,HYY_KPI_TEMPLATE,HYY_KPI_FLOW_STEP_ROLE,TB_PACT_ACC_EMAIL_ZKP,HYY_AUTH_APPLY_ASSISTANT,HYY_OVERTIME_DELETE_LOG,TEMP_STAFF_INFO,TB_PROC_JOB_TIME_LIMIT_VALUE,HYY_NOTICE_INFO,HYY_MANUSCRIPT_VERSION_INT,HYY_CO_APPLICATION_TYPE,HYY_COMPANY_CONFIG,HYY_CITY_COSTRATE,HYY_BOS_ROLE_MENU,HYY_BOC_TIMESHEET_DIFF,HYY_BOC_TERMINATION_ADD,HYY_BOC_TERMINATION,HYY_BOC_PERSONNEL_PRICE,HYY_BOC_MENU,HYY_BOC_FINAL_TIMESHEET,HYY_BOC_COMMON_PROJECT,HYY_BOC_CHANGE_ORDER_APPLY,HYY_AUTH_CONFIG,HYY_AGREEMENT_LIST_HIS,HYY_AGREEMENT_LIST,HYY_TECHNICAL_COOP_CONTROL,HYYDC_ORDER_FORECAST,TEMP_ZW_STAFF,HYY_CERTIFICATION_LEVEL_CONFIG,HYY_CERTIFICATION_SIM_CONFIG,HYY_CERTIFICATION_LINK_CONFIG,HYY_CERTIFICATION_ERROR,HYY_CERTIFICATION_LINK_EXP,TEMP_TRANS_PROJECT,TEMP_ORDER_STAFF_SID,TEMP_MONTHLY_PROJECT_CARRY,HYY_COOP_COST_RETURN_DETAIL_T,HYY_PERSON_SETTLE_RANGE,HYY_PERSON_SETTLE_CONFIRM,T1_HYY_EXPORT_RECORD,TEMP_ZW_HYY_OVERTIME_APPLY,TEMP_ZW_PROJECT_JZ,T_EVALUATION_RESUME_ROLE_ID,STAFF_EMAIL,HYY_MAN_HOUR_EXPORT_STAGING_T,PRJ_USER_ITF_RD,TMP_HYY_STAFF_PERCENT_COST,HYY_TECHNICAL_STAFF_IMPORT,TEMP_STAFF_COMMON_PRICE,TMP_HYY_STAFF_PERCENT_COST_DEL,HYY_PERCENT_MONTH,HYY_COOP_PERCENT_COST_LIMIT,OMC_RESULT_PROJECT_REPORT,TEMP_HYY_AD_SYNC_RECORD,AR_TERMS_EBC,HYY_OVERTIME_APPROVAL_END,TEMP_PERSON_EMAIL,WY_DETAIL,TEMP_APP_HUMAN_ENDDATE,HYY_AUTH_CONFIG_HIS,HYY_KPI_SETTING_STAFF_ZL找到原因了，是jumpserver用的ldap用户AIT-jumper的秘密到期了，刚才已经弄好了，已经改回ldap的方式登录了。AIT-jumper用户的最新密码是：P11111111111111
. . importing table "HYY_SETTLE_TIMESHEET" 23020900 rows imported
. . importing table "HYY_CO_ORDER_TIMESHEET" 13333745 rows imported
. . importing table "HYY_OA_INFO" 737966 rows imported
. . importing table "T1_BACKUP_EXPORT_STAGING" 4812828 rows importednohup imp aidba/IJdfdsf7_d5YT file=aidba_196.168.1.105_20250221_tables.dmp log=imp_aidba_196.168.1.105_20250221_tables.log grants=y tables=HYY_PROJECTS_ALL_HIS,HYY_HUMAN_ORDER_DETAIL_HIS,PRJ_USER_ITF,TIME_INFO,T1_PRJ_USER_ITF,HYY_CO_EXPENSE_SETTLEMENT,HYY_SUBMIT_EXPENSE_HIS,HYY_ORDER_APPLY_HIS,HYY_ORDER_TERMINATION_HIS,HYY_SAVE_EXPENSE_HIS,HYY_COMPUTE_REQUEST,BACKUP_MAN_HOUR_EXPORT_RESULT,HYY_CO_APPLICATION_PROCESS,HYY_CO_APPLICATION_PROCESS_HIS,HYY_STAFF_SYNC_HR_RECORD_HIS,TEMP_XXAI_PA_POM_COST_TS_T,HYY_EXPENSE_PROVISION_HIS,HYY_RESOURCE_POOL_HIS,HYYDC_ORDER_HUMAN_INFO,HYY_APP_APPLY_HIS,HYY_HUMAN_APP_DETAIL_HIS,HYY_RESOURCE_POOL_FORCAST,HYY_ORDER_TERMINATION,T1_BACKUP_EXPORT_RESULT,PRJ_USER_ITF_ALL,HYY_MANUSCRIPT_VERSION,HYY_EXPENSE_PROVISION,TEMP_HYY_EXPENSE_PROVISION_830,HYYDC_ORDER_APPLY,HYY_CO_APP_ATTACHMENT,HYY_VOUCHER_LATEMEAL_ITEM,AITS_EMPLOYEE_INFO_HISTORY,HYY_CHANGE_ORDER_APPLY_HIS,HYY_VOLUNTARILY_RECORD,HYY_SUBMIT_EXPENSE,HYYDC_ORDER_SAVE_EXPENSE,HYY_STAFF_SYNC_HR_RECORD,HYY_HUMAN_ORDER_DETAIL,HYYDC_ORDER_SUBMIT_EXPENSE,HYY_SAVE_EXPENSE,HYYDC_PAY_APPLY,AL_DATA_PROJECTS_ALL,AITS_PROJECT_TASKS_UPDATE,HYY_HUMAN_APP_DETAIL,PRJ_USER_ITF_ALL_HIS,AP_INTERFACE,HYY_KPI_SETTING_STAFF_SCORE,HYY_CHANGE_ORDER_APPLY,HYY_VOUCHER_TRAFFIC_ITEM,HYY_PERSON_CHANGE_APPLY_HIS,HYY_COSTRATE_RECORD,RETURN_AP,HYY_MAN_HOUR_EXPORT_STAGING,HYY_PLAN_APPLY_HIS,HYY_HUMAN_MONTHLY_EXPENSE,HYY_CERTIFICATION_EMAIL_LOG,HYY_HUMAN_ORDER_DETAIL_TEST,HYY_ORDER_APPLY,AII_EMPLOYEE_INFO_CUR_V,HYY_AD_SYNC_RECORD_HIS,HYY_PERSON_SETTLE_STAFF,HYY_ALL_FORCAST_TABLE,HYY_SDP_LABOR,AITS_PROJECT_TASKS_UPDATE_TEMP,HYY_ORDER_ACCOUNT_DETAIL,AII_EMPLOYEE_COSTCENTER_ALL_DP,HYY_RESUME_PROJECT_EXPERIENCE,HYY_SYNC_STAFF_HIS,HYY_RESUME_FILE,HYY_LEAVE_FILE,T1_HYY_EXPORT_STAGING,TEMP0_MAN_HOUR_EXPORT_STAGING,HYY_KPI_SETTING_STAFF,PRJ_USER_ITF_HIS,HYY_APPROVAL_PERSON_HIS,HYY_AD_SYNC_RECORD,HYY_APP_APPLY,HYY_APPROVE_PROCESS_APPLY,HYY_ORDER_BACKFILL_PAY,HYY_PROJECT_APP_DETAIL_HIS,HYY_PROJECTS_ALL,HYY_CLAIM_VOUCHER_APPLY,HYY_EVALUATION_RESUME,HYY_TECHNICAL_STAFF,HYY_RECRUIT_INTERVIEW_RESULT,HYY_STAFF_PERCENT_COST,PRJ_PFM_MONTH_ITF,HYY_VOUCHER_APPLY_FLOW,HYY_PERSON_CHANGE_APPLY,HYY_PROJECT_APP_DETAIL,TEMP_EMPLOYEE,HYYDC_ORDER_SPLIT_RANGE,HYY_TECH_MONTHLY_EXPENSE,TB_ITEM_BUDGETVERSION,PRJ_USER_ITF_TEMP,HYYDC_ORDER_HUMAN_NUM,TBDATAOPERATE_LOG,HYY_SDP_PROJECT,HYY_AD_LOGS,HYY_NO_PROJECT_APP_DETAIL_HIS,HYY_OVERTIME_SHEET_REFRESH,PA_INTERFACE,HYY_PROVISION_APP_RELATION,HYY_BU_AREA_PERMISSION,HYY_RELEASE_LOG,HYY_RESUME_SKILLS,HYY_RESUME_WORK_EXPERIENCE,HYY_OVERTIME_APPLY_DETAIL,HYY_OVERTIME_DISTRIBUTION,HYY_OVERTIME_TEMPLATE,HYY_WRITEOFF_MONTHLY_EXPENSE,OSBC_BUSINESS_INFORMATION,HYY_OVERTIME_APPLY,HYY_PERSON_CHANGE_DETAIL,HYY_PLAN_APPLY,HYY_SCORE_ENTER,HYY_RECRUIT_DEMAND,TEST_SJ,HYY_OVERTIME_IMPORT_INFO,HYY_PERSON_CHANGE_DETAIL_HIS,HYYDC_ORDER_RANGE,TB_ITEM_MILESTONE,HYY_PERSON_CHANGE_RELEASE_LOG,HYY_RELEASE_OVERTIME_DETAIL,HYY_RECRUIT_TASK_RESUME_RECORD,HYY_SDP_THIS_MONTH_LABOR,RETURN_PA,HYY_ORDER_SIGNDATE_BACKFILL,HYY_HUMAN_PLAN_DETAIL,HYY_NO_PROJECT_APP_DETAIL,HYY_ZB_MONTHLY_EXPENSE,HYY_STAFF_SCORE,HYY_CERTIFICATION_STAFF_RECORD,HYY_RECRUIT_TASK_RESUME,HYY_VOUCHER_APPLY_WRITEOFF,HYY_TBDATAOPERATE_LOG,HYY_TEMP_SETTLE_TIMESHEET,HYY_SENDMAIL_SIZE,HYY_DAY_LOGIN,HYY_APPROVE_RESUME,HYY_ENTRY_CLERK_STAFF_DETALL,HYY_DIRECT_MANAGER,HYY_VOUCHER_APPLY_RELATION,HYY_PROVISION_ACCEPT,HYY_ORDERLIST_INTERFACE,HYY_ORDERLIST_ALL,HYY_RECRUIT_TASK_OFFICE_FLOW,HYY_RECRUIT_RESUME_OPT,HYY_RESUME_EDU_EXPERIENCE,HYY_POM_PROJECT_TIMESHEET,HYY_STAFF_PERSON,HYY_PUSH_RESUME_OPT,HYY_KPI_FLOW_LOG,HYY_KPI_SETTING_STAFF_LEVEL,HYY_AUDITION_RESUME_FLOW,HYY_RECRUIT_RESUME,HYY_APP_ORDER_MONEY_INFO,HYY_APPROVAL_PERSON,AITS_PROJECT_INFORMATION_RD,HYY_ORDER_TERMINATION_ADD_HIS,TEMP_PROJECT_TASKS,HYY_ENTRY_CLERK_APPLY,HYY_TECHNICAL_COOPERATION_HIS,TEMP_EXPENSE_SETTLEMENT,HYY_RECRUIT_TASK,HYY_COOP_COST_DEDUCTION_DETAIL,TMP_AII_ORG_COSTCENTER_CUR_V,HYY_STAFF_EDU_INFO,TEMP_HYY_STAFF_EDU_INFO,HYY_CERTIFICATION_TEST_RECORD,TEMP_HYY_HUMAN_APP_DETAIL,PA_PROJECTS_ALL_CURRENCY,HYY_SDP_LABOR_BUDGET,HYY_EXAM_MAKEUP,HYY_KPI_FLOW_STEP,HYY_MODIFY_ORDER_RECORD,HYY_RESOURCE_POOL_FLOW,HYY_STAFF_BANKCARD_REVIEW,HYY_COMMON_PRICE_APPLY,HYY_MANUSCRIPT_CC,HYY_CHANGE_LOG,TEMP_FML,HYY_VOUCHER_TRAVEL_ITEM,HYY_SELECTED_RESUME_NEW,HYY_ORDER_TERMINATION_ADD,TEMP_ZW_ORDER,HYY_SCHOOL_INFO,TEMP_PERSON_CID,HYY_RESULT_ENTITY,HYY_MANAGERS_POOL,HYY_SELECTED_RESUME,ERP_INTERFACE_DAILY,HYY_KPI_SETTING,HYY_INPUT_FORCAST_DETAIL_HIS,HYY_PURCHASE_MACHINE,TEMP_STAFF_BANK_INFO,HYY_SDP_THIS_MONTH_LABOR_DAILY,HYY_SBU_LARGEAREA,AITS_PROJECT_MANAGERS_RD,HYY_CO_BOC_TIMESHEET,TEMP_CARD_ESTABLISHMENT_ALL,HYY_SBU_LARGEAREA_HIS,TEMP_CARD_ESTABLISHMENT,HYY_ZB_SAVE_EXPENSE,HYY_SENDMAIL_SIZE_ZZ,HYY_PLAN_APP_MONEY_INFO,HYY_TEMP_AIAD_ACCOUNT,HYY_DMP_SYNC_HOLIDAY,HYY_AD_TEMP_CHECK,HYY_COOP_COST_RETURN_COMP,TEST_CHENLIU,HYY_COOP_COST_RETURN_DETAIL,HYY_PROJECT_INFORMATION,NEWMIS_CCOWNER,HYY_APPROVE_PROCESS_STEP,HYY_TECHNICAL_COOPERATION,HYY_TECH_SRV_PLAN_DETAIL,HYY_TECHNICAL_STAFF_TEMP,HYY_HUMAN_PLAN_DETAIL_HIS,HYY_EXAM_MAKEUP_PROCESS,HYY_KPI_WEIGHT,HYY_BOC_EMPLOYEE_INFO,PRJ_PFM_MONTH_ITF_TEMP,TMP_OOA_EMAIL,HYY_PROJECT_MANAGERS,HYY_APPLYER_AGENT,HYY_SUSPEND_APPLICATION,HYY_RESOURCE_POOL,HYY_INPUT_FORCAST_HIS,HYY_ZB_ORDER,HYY_VOUCHER_INVOICE,HYY_PROBATION_INFO,HYY_COOP_COST_RETURN_DETAIL_2A,HYY_BANK_INFO,HYY_PURCHASE_MACHINE_DETAIL,HYY_LOCK_USER,HYY_TIMESHEET_SESSION_DATE,TEMP_IDENTIFICATION,HYY_ZZ_EMAIL_HIS,HYY_APPROVER_AGENT,TEMP_PERSON,HYY_PERSON_CHANGE_INFO_DETAIL,HYY_PERSON_CHANGE_INFO_APPLY,TEMP_TIMESHEE,HYY_MAN_HOUR_EXPORT_LOG,HYY_TEMP_TECHNICAL_STAFF,HYY_STAFF_SALARY,HYY_BUSINESS_MANAGER,HYY_BOC_ORDER_APPLY,HYY_BASEDATA_VINDICATE,HYY_OA_TASKTRACT,HYY_RESOURCE_POOL_FILLRATE,HYY_TIMESHEET_APPROVER_AGENT,PRJ_USER_ITF_ERR,TEST_CL_DATA,HYY_ROLE_MENU,TEST_ZKP,HYY_APPROVE_PROCESS_CONFIG,HYY_CO_EXPENSE_SETTLEMENT_HIS,HYY_MANUSCRIPT_STEP,HYY_MANUSCRIPT_STEP_LOG,HYY_ORDER_CODE,HYY_EMAIL_TEMPLETE,HYY_INPUT_FORCAST_DETAIL,HYY_LARGEAREA,HYY_HUMAN_BOC_ORDER_DETAIL,HYY_RESUME_CERTIFICATE,HYY_AUDITION_FLOW_BACK_LOG,ORDER_DETAIL,T1_HYY_EXPORT_LOG,TB_ITEM_BIND_INFO,HYY_TIMESHEET_SESSION,HYY_TIMESHEET_ROLE_MENU,HYY_TIMESHEET_MENU,HYY_TIMESHEET_BOC_APPROVER,HYY_TIMESHEET_AUTH_CONFIG,SDP_MIXED_PROJECT_FINAL,QUERY_PERMISSION_CONFIG,TEMP_HYY_TECHNICAL_STAFF,YJY_TEMP,T_LYW,HYY_SDP_AREA_MAPPING,AL_DATA_AREA_S,HYY_MOVE_STAFF,AITS_TIMESHEET_SESSION_DATE,AITS_TIMESHEET_SESSION,HYY_APPROVAL_ROLE,HYY_APPLICATION_CODE,HYY_APPROVE_ROLE_MAX_MONEY,AII_REGION_V,HYY_CORPORATE_VIOLATIONS,HYY_PAYMENT_REPORT,HYY_LEVEL_MAPPING,HYY_CO_APP_BUSINESS_TYPE,HYY_FAIL_POOL,HYY_EX_OPEN_CLOSE_TIME_HIS,HYY_TIME_WINDOW,HYY_TEMP_PLAN_FORCAST,HYY_TECH_SRV_PLAN_DETAIL_HIS,HYY_BG_ASSIGNER,HYY_SIGN_FOCUS,HYY_SETTLE_TIMESHEET_HIS,HYY_MANUSCRIPT_FLOW,HYY_MANUSCRIPT_CANCEL,HYY_OLD_PROJECT_POOL,HYY_EX_OPEN_CLOSE_TIME,HYY_DOCUMENT_MANAGE,HYY_DEV_CONSTANT,HYY_INPUT_FORCAST,HYY_HUMAN_ORDER_DETAIL_TMP,HYY_MENU,PROJECTS_RELATION_CORRESPOND,HYY_VALID_COMPANY,HYY_VALID_BU,HYY_USER_ROLE,HYY_TIMESHEET_USER_ROLE,HYY_TIMESHEET_SESSION_STATUS,AII_BG_V,HYY_BLACK_RESUME,HYY_COST_COEFFICIENT,HYY_RECRUIT_CONSULTANTS,HYY_RECRUIT_ENTRY_PROGRESS,HYY_APPROVE_AGENT_TEMP_D,HYY_APPROVE_AGENT_TEMP,HYY_APP_MONEY_CHANGE_FLOW,TEMP_PA_PROJECT,HYY_MAN_HOUR_EXPORT_RECORD,TEMP_WX,TMP_HYY_CO_ORDER_TIMESHEET,HYY_BLACKLIST,HYY_KPI_QUARTER,HYY_KPI_TARGET,HYY_KPI_TEMPLATE_TARGET,HYY_KPI_TEMPLATE,HYY_KPI_FLOW_STEP_ROLE,TB_PACT_ACC_EMAIL_ZKP,HYY_AUTH_APPLY_ASSISTANT,HYY_OVERTIME_DELETE_LOG,TEMP_STAFF_INFO,TB_PROC_JOB_TIME_LIMIT_VALUE,HYY_NOTICE_INFO,HYY_MANUSCRIPT_VERSION_INT,HYY_CO_APPLICATION_TYPE,HYY_COMPANY_CONFIG,HYY_CITY_COSTRATE,HYY_BOS_ROLE_MENU,HYY_BOC_TIMESHEET_DIFF,HYY_BOC_TERMINATION_ADD,HYY_BOC_TERMINATION,HYY_BOC_PERSONNEL_PRICE,HYY_BOC_MENU,HYY_BOC_FINAL_TIMESHEET,HYY_BOC_COMMON_PROJECT,HYY_BOC_CHANGE_ORDER_APPLY,HYY_AUTH_CONFIG,HYY_AGREEMENT_LIST_HIS,HYY_AGREEMENT_LIST,HYY_TECHNICAL_COOP_CONTROL,HYYDC_ORDER_FORECAST,TEMP_ZW_STAFF,HYY_CERTIFICATION_LEVEL_CONFIG,HYY_CERTIFICATION_SIM_CONFIG,HYY_CERTIFICATION_LINK_CONFIG,HYY_CERTIFICATION_ERROR,HYY_CERTIFICATION_LINK_EXP,TEMP_TRANS_PROJECT,TEMP_ORDER_STAFF_SID,TEMP_MONTHLY_PROJECT_CARRY,HYY_COOP_COST_RETURN_DETAIL_T,HYY_PERSON_SETTLE_RANGE,HYY_PERSON_SETTLE_CONFIRM,T1_HYY_EXPORT_RECORD,TEMP_ZW_HYY_OVERTIME_APPLY,TEMP_ZW_PROJECT_JZ,T_EVALUATION_RESUME_ROLE_ID,STAFF_EMAIL,HYY_MAN_HOUR_EXPORT_STAGING_T,PRJ_USER_ITF_RD,TMP_HYY_STAFF_PERCENT_COST,HYY_TECHNICAL_STAFF_IMPORT,TEMP_STAFF_COMMON_PRICE,TMP_HYY_STAFF_PERCENT_COST_DEL,HYY_PERCENT_MONTH,HYY_COOP_PERCENT_COST_LIMIT,OMC_RESULT_PROJECT_REPORT,TEMP_HYY_AD_SYNC_RECORD,AR_TERMS_EBC,HYY_OVERTIME_APPROVAL_END,TEMP_PERSON_EMAIL,WY_DETAIL,TEMP_APP_HUMAN_ENDDATE,HYY_AUTH_CONFIG_HIS,HYY_KPI_SETTING_STAFF_ZL 
.19.9390
exp aidba/IJh8987_d5YT file=aidba_10.19.93.90_20250221.dmp log=aidba_10.19.93.90_20250221.log buffer=10240000 grants=y rows=y statistics=none
exp aidba/IJh8987_d5YT file=aidba_10.19.93.90_20250221001_nodata.dmp log=aidba_10.19.93.90_20250221001_nodata.log buffer=10240000 grants=y rows=no statistics=none
SELECT segment_name AS table_name,
segment_type AS table_type,
bytes / 1024 / 1024 AS size_mb
FROM dba_segments a
WHERE segment_type = 'TABLE' and a.owner='aidba'
ORDER BY size_mb DESC;1 HYY_TECHNICAL_STAFF_HIS TABLE 61398
2 HYY_CO_ORDER_TIMESHEET_HIS TABLE 19104
另外上面这两张表你们要是不需要就不导了，因为这两张表很大。@大洪锋 @张佳柱 @茅荣正
--drop table aidba.HYY_TECHNICAL_STAFF_HIS;
--drop table aidba.HYY_CO_ORDER_TIMESHEET_HIS;###############################################################