各种原因导入被终止后，需要重新导入数据。
1.找出一条记录都没导的表
2.找出已经导入记录的表，对比生产表，导入不全的考虑重导
3.编辑脚本后台导入
[root@lnob ~]# obclient -h192.168.207.28 -P2881 -ugistar@lnzyob -pxxxxxx. -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221622216
Server version: OceanBase 4.2.5.4 (r104030022025070212-37927c3517f028002a34b40302f78cce88afdbd9) (Built Jul 2 2025 12:21:09)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient(GISTAR@lnzyob)[GISTAR]>
obclient(GISTAR@lnzyob)[GISTAR]> select distinct segment_name from user_segments where segment_type='TABLE PARTITION' and segment_name not in(select distinct segment_name from user_segments where bytes>2 and segment_type='TABLE PARTITION') order by 1;
+-------------------------------+
| SEGMENT_NAME |
+-------------------------------+
| CABLE_CONNECTOR_ROUTE_DESIGN |
| CABLE_CONNECTOR_ROUTE_HISTORY |
| CUST_ACCOUNT |
| CUST_DATALINK |
| CUST_SERVICE_USER_RELATION |
| CUST_SPECIALLINE |
| CUST_VAS |
| DA_BRAS_PORT |
| DA_CIR_IP_LN_HIS |
| DA_CIR_IP_LN_HISTORY |
| DES_CONTACT |
| DES_DATALINK |
| DES_INTERFACEMESSAGE |
| DES_SPECIALLINE |
| DES_VAS |
| DICT_PREMISES_NETWORK_LOG |
| G_TEMP_TAB |
| INSTANCE |
| IPLANROUTE |
| IPLANROUTE_DESIGN |
| IPLANROUTE_HISTORY |
| IP_RESOURCE |
| MEASURE_ROUTE_DESIGN |
| MEASURE_ROUTE_HISTORY |
| PXPH_PON_ROUTE_DESIGN |
| PXPH_PON_ROUTE_HISTORY |
| RESERVE_NBR |
| RESERVE_WIRELESS_NBR |
| SENSITIVE_DATA_OPER_LOG |
| SW_NUMBER_RES_BAS |
| SW_TEL_PORT |
| TASKBILL |
| TEL_SEG_LOGIC |
| TEL_SEG_PHYSIC |
| TR_DDF_TERM_CONN |
| TR_PORT_PHY_CONN |
| UNUSED_NBR |
| UNUSED_WIRELESS_NBR |
| ZY_BUILD_ADDR |
+-------------------------------+
39 rows in set (0.045 sec)
obclient(GISTAR@lnzyob)[GISTAR]>
obclient(GISTAR@lnzyob)[GISTAR]> select distinct segment_name from user_segments where segment_type='TABLE' and segment_name not in(select distinct segment_name from user_segments where bytes>0 and segment_type='TABLE') order by 1;
+--------------------------------+
| SEGMENT_NAME |
+--------------------------------+
| ACTION |
| ACTIVITY |
| ACTIVITYRESTRICT |
| ADDRESS_STAFF_RELATION |
| ANSWER |
| AN_AGCF_LIST |
| AN_COMBINER |
| AN_COMBINER_CONN |
| AN_COMBINER_PORT |
| AN_EQUIP_PREMISES_NETWORK_LOG |
| AN_FTTBONU_CUTOVER_LOG |
| AN_FTTB_CUTOVER_GEGATEWAY_TASK |
| AN_FTTB_CUTOVER_GEG_INTLOG |
| AN_FTTB_CUTOVER_GEG_PORTLIST |
| AN_HOMEGATEWAY |
| AN_HOMEGATEWAY_PORT |
| AN_LOGIC_CONN_LOG |
| AN_LOGIC_CONN_LOG_JR |
| AN_NAS_IP |
| AN_ODN_128SPLIT_LOG |
| AN_ODN_128SPLIT_LOG_DETAIL |
| AN_ODN_DILATATETERM_LOG |
| AN_ODN_FINISHRENOVATE_STATUS |
| AN_OLT |
| AN_OLTCARD_CUTOVER_LOG |
| AN_OLTCARD_CUTOVER_ONULIST |
| AN_OLTPORTOFFLINECUT_DETAIL |
| AN_OLTPORTOFFLINECUT_ONULIST |
| AN_OLTPORTOFFLINECUT_TASK |
| AN_OLTPORT_CUTOVER_INTERFACE |
| AN_OLTPORT_CUTOVER_TASK |
| AN_OLT_CARD |
| AN_OLT_CUTOVER_INTLOG |
| AN_OLT_CUTOVER_OLTLIST |
| AN_OLT_CUTOVER_PORTLIST |
| AN_OLT_CUTOVER_RESOURCE |
| AN_OLT_CUTOVER_TASK |
| AN_OLT_DDF_CONN |
| AN_OLT_PANEL |
| AN_OLT_PORT_CONN |
| AN_OLT_SLOT |
| AN_OLT_SLOT_CARD |
| AN_OLT_SUBRACK |
| AN_ONU_CARD |
| AN_ONU_DDF_CONN |
| AN_ONU_ONTID_CONVERT |
| AN_ONU_PORTTEL |
| AN_ONU_PORT_CONN |
| AN_ONU_SLOT |
| AN_ONU_SLOT_CARD |
| AN_ONU_SUBPORT |
| AN_PONOLT_OPER_LOG |
| AN_RENOVATE_VERIFY |
| AN_SBCIP_LIST |
| AN_TPONU_CONFIG |
| AN_USER_PROTOCOL_LIST |
| AN_V5ID_LOG |
| AN_WOANFANG_IP_ADDR |
| AN_WOANFANG_IP_POOL |
| BRAS |
| BROADACCESSGRID |
| BUILD_INSTAFF_RELATION |
| BUILD_STAFF_RELATION |
| CABLE_BOX |
| CABLE_BOX_BLOCK |
| CABLE_CONNECTOR_SEGMENT |
| CODE_GRADE |
| CUST_ACCOUNTRELATION |
| CUST_CUSTOMERKEYVALUE |
| CUST_CUSTOMERRELATIONSHIP |
| CUST_LARGEACCOUNT |
| CUST_SERVICEKEYVALUE |
| CUST_VASKEYVALUE |
| DA_ADSL |
| DA_ADSL_AREA |
| DA_ADSL_CARD |
| DA_ADSL_CARD_SLOT |
| DA_ADSL_DDF_CONN |
| DA_ADSL_NE |
| DA_ADSL_NON_OPERATION_PORT |
| DA_ADSL_ODF_CONN |
| DA_ADSL_OTB_CONN |
| DA_ADSL_PANEL |
| DA_ADSL_PDH_CONN |
| DA_ADSL_PORT_CONN |
| DA_ADSL_PREMISES |
| DA_ADSL_SDH_CONN |
| DA_ADSL_SLOT |
| DA_ADSL_VDF_CONN |
| DA_ADSL_VLAN_CONFIG |
| DA_ADSL_VLAN_NE |
| DA_ATM_DDF_CONN |
| DA_ATM_PDH_CONN |
| DA_BRAS |
| DA_BRAS_AREA |
| DA_BRAS_CARD |
| DA_BRAS_CARD_SLOT |
| DA_BRAS_NE |
| DA_BRAS_NE_IPAADD |
| DA_BRAS_NON_OPERATION_PORT |
| DA_BRAS_ODF_CONN |
| DA_BRAS_OTB_CONN |
| DA_BRAS_SCHOOLDOMAIN |
| DA_BRAS_SLOT |
| DA_CIR_ADSL_IPADDR_LN |
| DA_CIR_IPADDR_LN |
| DA_CIR_IP_IP_LN |
| DA_CIR_LANROUTE_IPADDR_LN |
| DA_CIR_LANROUTE_IPADDR_LN_HIS |
| DA_CIR_LANROUTE_IP_LN |
| DA_CIR_LAN_LN |
| DA_CIR_LAN_LN_HISTORY |
| DA_DDN_DACS_CONN |
| DA_DDN_DDF_CONN |
| DA_DDN_PDH_CONN |
| DA_DDN_SDH_CONN |
| DA_DDN_VDF_CONN |
| DA_DSLAM_CHANGE_LOG |
| DA_FR_DACS_CONN |
| DA_IP_AREA |
| DA_IP_CARD |
| DA_IP_CARD_SLOT |
| DA_IP_DDF_CONN |
| DA_IP_NE |
| DA_IP_NON_OPERATION_PORT |
| DA_IP_ODF_CONN |
| DA_IP_OTB_CONN |
| DA_IP_PANEL |
| DA_IP_PDH_CONN |
| DA_IP_PORT_CONN |
| DA_IP_SDH_CONN |
| DA_IP_SLOT |
| DA_MODEM_DDF_CONN |
| DA_MODEM_PDH_CONN |
| DA_MODEM_VDF_CONN |
| DA_OTHER_DDF_CONN |
| DA_OTHER_PDH_CONN |
| DA_OTHER_SDH_CONN |
| DES_CHECK_ORDER |
| DES_CONFIG_BILL_LIST |
| DES_ERRORMSG_LOG |
| DES_FINALIZE_FAIL |
| DES_HOLDUP_CUTOVER |
| DES_HTTP_MESSAGE |
| DES_HTTP_MESSAGE_HIS |
| DES_HTTP_MESSAGE_STATUS_HIS |
| DES_REGION_CONFIG |
| DES_SERVICEKEYVALUE |
| DES_SOEXCEPTION |
| DES_VASKEYVALUE |
| DEV_AUTH_DATA |
| DEV_AUTH_UI |
| DEV_BUTTON |
| DEV_PERMISSION |
| DGY_FIBERCHANGE_TJ |
| DICT_BAS |
| DICT_CONFIG_BILL_STATUS |
| DICT_CPN_EXT_INFO |
| DICT_CPN_INFO |
| DICT_DAIWEIDEPT |
| DICT_DESIGN_BILL_STATUS |
| DICT_DEVELOP |
| DICT_IMS_LOCATIONCODE |
| DICT_INFO |
| DICT_IPADDR_DOMAIN |
| DICT_LOGIC_TYPE |
| DICT_MAINTENANCE_UNIT |
| DICT_ORDER_MODE |
| DICT_PROJECT |
| DICT_RESOURCE_SEGMENT |
| DICT_SAP |
| DICT_SERVICEORDER_STATUS |
| DICT_SERVICE_ORDER_TYPE |
| DICT_SERVICE_TYPE |
| DICT_SOTYPEID_SERVICETYPEID |
| DICT_SUPPORTBUSINESSTYPE |
| DICT_XLPH_SOTYPE |
| EQUIPMENT_ADDRESS_LOG |
| EQUIP_BUILDING |
| EQUIP_EXCHANGE |
| EQUIP_EXCHANGE_PORT |
| EQUIP_PREMISESNETWORK_LOG |
| EQUIP_ROOM |
| ESA_BROADBAND_INTERFACE |
| ESA_CUTOVER_TASK |
| FACTORY |
| FACTORY_INFO |
| FIXORDERCOPY |
| G_DEVICE_LOG |
| G_EQUIP_TYPE |
| G_NET_LEVEL |
| G_PARAM |
| G_RESOURCE |
| HP_DELETE_ORDER_LOG |
| HTTP_ACTION_LOG |
| IMS_SPG |
| INSTANCECHANGELOG |
| INSTANCELOG |
| INT_RESCONFIRM_LOG |
| IPLAN |
| IPRAN_CIRCUIT |
| IPRAN_CONFIRMWAIT |
| IPRAN_NE |
| IPRAN_PORT |
| IPRAN_PORT_ADDR |
| IPRAN_WAITNOTIFY_INTERFACE |
| JIAOWEI_INFO |
| JIAOWEI_INFO_DETAIL |
| JYC |
| MDF_CONTAINER |
| MDF_FRAME |
| MDF_VDF_TERM_CONN |
| METHODPARAMETER |
| NBR_ONENBR_ONLY |
| NBR_PHSBODYCONFIGURE |
| NETWORKSWITCHEQP |
| NGN_AG |
| NGN_SS |
| NUMBER_STATUS |
| OAS_INTERFACEMESSAGE |
| OAS_PONCUTOVER_WAIT |
| ODB |
| ODB_CARD |
| ODF |
| ODM |
| OPERATIONSTAFF |
| OPTCABLE_FIBER |
| OSS_EQUIP_BUILD |
| OSS_EQUIP_BUILD_LOG |
| OSS_EQUIP_PLACEMENT |
| OSS_EQUIP_PLACEMENT_LOG |
| OSS_EQUIP_ROOM |
| OSS_EQUIP_ROOM_LOG |
| OSS_ONU_RXPOWER |
| PHONETYPE_VS_GRADE |
| PIECE_AREA |
| PPPOE_IPOE_INTERFACE |
| PROCESS |
| PROCESSCATEGORY |
| PROCESSVAR |
| PROCESSVERSION |
| PROJECT_EQUIPCONN |
| PXPH_FTTH_CONFIG_LOG |
| PXPH_ROUTEUPDATELOG |
| PXPH_TABLEPARTITIONNAME |
| RESOURCE_TYPE |
| RME_EQP_DATA_JT |
| RME_ROUTE_EQP_CB |
| RMIAPP |
| RMICATALOG |
| ROUTER |
| ROUTEREQP |
| ROUTERRESTRICT |
| SEGMENT_LOG |
| SHAPETABLE |
| SID_AREA |
| SID_AREACODE |
| SID_BUSINESSAREA |
| SID_CHLCHANNEL |
| SID_CONSTANTITEMDEF |
| SID_CONSTANTTYPEDEF |
| SID_DEPART |
| SID_LATN |
| SID_MAINTENANCEAREA |
| SID_REGION |
| SID_STAFF |
| SS_ATTACH_FILE |
| SS_ATTACH_FILECOMPLETED |
| SS_ATTACH_INFO |
| SS_ATTACH_INFOCOMPLETED |
| SS_ATTACH_SEQUENCE |
| SS_ATTACH_TYPE |
| STATERESTRICT |
| SUBSTATION |
| SW_FARMOD |
| SW_IP_ADDR_LOG |
| SW_IP_POOL |
| SW_PORT_PHY_CONN |
| SW_SWITCH |
| SW_TPORT_DTERM |
| SW_V6_IP_POOL |
| SW_V6_IP_SEGMENT |
| SW_ZONE_NUMBER |
| SYNC_G_PARAM |
| SYNODNSPLIT_INTERFACE_DETAIL |
| SYNODNSPLIT_INTERFACE_MESSAGE |
| SYNTH_BOX |
| SYS_CAPTCHA |
| SYS_CONFIG |
| SYS_DICTIONARY |
| SYS_DICTIONARY_ITEM |
| SYS_ENTITY_ATTACHMENT |
| SYS_ENTITY_CONFIG |
| SYS_ENTITY_FIELD_CONFIG |
| SYS_ENTITY_FORM_RULE |
| SYS_ENTITY_FORM_RULE_CONDITION |
| SYS_ENTITY_FORM_RULE_CONTROLS |
| SYS_ENTITY_SEARCH_CONFIG |
| SYS_ENTITY_SEARCH_FIELD_CONFIG |
| SYS_ENTITY_SEQUENCE |
| SYS_GIS_LAYER_CONFIG |
| SYS_GIS_LAYER_DETAIL |
| SYS_GIS_LAYER_SEARCH |
| SYS_GIS_MAP_CONFIG |
| SYS_GIS_SERVER_CONFIG |
| SYS_GROUP_ROLE_RELATION |
| SYS_LOG |
| SYS_MENU |
| SYS_OP_LOG |
| SYS_ORG |
| SYS_ORG_POST_RELATION |
| SYS_OSS |
| SYS_REPORT |
| SYS_REPORT_ITEM |
| SYS_REPORT_PARAM |
| SYS_ROLE |
| SYS_ROLE_MENU |
| SYS_UIC_COMP |
| SYS_UIC_COMP_DIR |
| SYS_UIC_COMP_EVENT |
| SYS_UIC_COMP_METHOD |
| SYS_UII_COMP |
| SYS_UII_PAGE |
| SYS_UII_PAGE_DIR |
| SYS_USER |
| SYS_USERS_GROUP |
| SYS_USER_GROUP_RELATION |
| SYS_USER_HISTORY |
| SYS_USER_POST_RELATION |
| SYS_USER_ROLE |
| SYS_USER_TOKEN |
| TASKATTACH |
| TASKATTACHCOMPLETED |
| TASKBILLCOMPLETED |
| TASKCHANGELOG |
| TASKCOMPLETED |
| TASKLOG |
| TD_M_AREA_ADDRESS_SYNC |
| TEL_LATN_CONFIGURE |
| TEL_NBR_BROADBAND_LOG |
| TEL_NBR_JX |
| TEL_NBR_LOGIC_LOG |
| TEL_NBR_PHYSIC_LOG |
| TEL_SEGMENTUSAGE |
| TEL_SEG_BROADBAND |
| TEL_SEG_BROADBAND_LOG |
| TEL_SEG_LOGIC_LOG |
| TEL_SEG_PHYSIC_LOG |
| TEMPTASKLIST |
| TEMP_CONFIG_RESULT_LOG |
| TMP_HX_WAIT |
| TP_ACCESSNET_NE |
| TP_ACCESSNET_PORT |
| TP_CARD |
| TP_CARD_PORT_RELATION |
| TP_CARD_RELATION |
| TP_CARD_SLOT |
| TP_CB_CARD_SLOTS |
| TP_DATA_PORT |
| TP_EQUIP_CONFIGURE |
| TP_FACTORY_CARD_TYPE |
| TP_NE |
| TP_NE_RELATION |
| TP_SHELF |
| TP_SLOT_BASIC_INFO |
| TP_SUBSHELF_PORT_RALATION |
| TP_SUB_SHELF |
| TP_TEMP_EXTEND |
| TRSN_NE |
| TRSN_NE_IPRAN |
| TRSS_NE |
| TR_DDF |
| TR_DDM |
| TR_DWDM_CARD |
| TR_DWDM_CARD_SLOT |
| TR_DWDM_NE |
| TR_DWDM_NE_FIX |
| TR_DWDM_SLOT |
| TR_LOGIC_PORT |
| TR_OTHER_CARD |
| TR_OTHER_CARD_SLOT |
| TR_OTHER_NE |
| TR_OTHER_NE_FIX |
| TR_OTHER_PORT |
| TR_OTHER_SLOT |
| TR_PCM_CARD |
| TR_PCM_CARD_SLOT |
| TR_PCM_NE |
| TR_PCM_NE_FIX |
| TR_PCM_PORT |
| TR_PCM_SLOT |
| TR_PDH_CARD |
| TR_PDH_CARD_SLOT |
| TR_PDH_OTM |
| TR_PDH_OTM_FIX |
| TR_PDH_PORT |
| TR_PDH_SLOT |
| TR_RACK |
| TR_SDH |
| TR_SDH_CARD |
| TR_SDH_CARD_SLOT |
| TR_SDH_NE |
| TR_SDH_NE_FIX |
| TR_SDH_PANEL |
| TR_SDH_PORT_CONN |
| TR_SDH_RING |
| TR_SDH_RING_CONN |
| TR_SDH_SLOT |
| TR_TPORT_VTERM |
| TR_VDF |
| TR_VDF_TERM_CONN |
| TR_VDM |
| TR_VDM_LOGIC_TERM |
| UPCABLE_BOX |
| USER_BRANCH_RELATION |
| USER_REGION_RELATION |
| VARCHANGELOG |
| VARCOMPLETED |
| WORKFLOWCONFIG |
| XL_BROADBANDWAIT |
| XL_CONFIRMWAIT |
| XL_WAIT_INFO |
| ZTWG_CIRCUIT |
| ZTWG_EQUIP |
| ZT_CIRCUIT_ESA |
+--------------------------------+
425 rows in set (0.293 sec)
obclient(GISTAR@lnzyob)[GISTAR]>
有记录的表：
obclient(GISTAR@lnzyob)[GISTAR]> select distinct segment_name from user_segments where bytes>0 and segment_type='TABLE' order by 1;
+----------------------------+
| SEGMENT_NAME |
+----------------------------+
| ADDR_SEGM |
| AN_LAN_IPTV_PORT |
| AN_LOGIC_CONN |
| AN_NE_DEVICE |
| AN_ODN |
| AN_ODN_CARD |
| AN_ODN_PICTURE |
| AN_OLT_PORT |
| AN_ONU |
| AN_ONU_ODF_CONN |
| AN_ONU_PANEL |
| AN_ONU_RELEASE_INFO |
| AN_ONU_SUBRACK |
| AN_TOPO_LINE |
| AN_TOPO_NE |
| AN_V5ID |
| AN_VLAN_POOL |
| AN_VLAN_PORT |
| AN_VLAN_PORT_LOG |
| AR_PONROUTE |
| AR_SERVICE |
| CABLEEQUIP_CHANGE_LOG |
| CUST_USERACCOUNT |
| DA_ADSL_CARD_CARD |
| DA_IP_NE_PORT |
| DA_IP_NE_PORT_DELETE_LOG |
| DA_IP_PORT_DELETE_LOG |
| DECOUPLE_FTTHONU_INTERFACE |
| DES_AUTOCONFIG_LOG |
| DES_RECONFIG_INFO |
| DES_SERVICEORDER |
| DES_USERACCOUNT |
| DEVICE_GIS |
| DICT_PREMISES_NETWORK |
| FIXORDER |
| FTTHONU_SO |
| G_RACK_FIXING |
| G_ROOM_FIXING |
| INSTANCECOMPLETED |
| MDF_BLOCK |
| OTB |
| POLE |
| RME_OPTIC_TERM_JT |
| SW_IP_ADDR |
| SW_V6_IP_ADDR |
| SYS_USER_ROLE_AREA |
| THIRD_ONU_SUPPORT200M |
| TR_ODF_TERM |
| TR_SDH_PORT |
| WORKING_STATUS |
| XL_WAITHISTORY |
+----------------------------+
51 rows in set (0.022 sec)
obclient(GISTAR@lnzyob)[GISTAR]> select count(*) from ADDRESSINFO;
+----------+
| COUNT(*) |
+----------+
| 2503061 |
+----------+
1 row in set (2.778 sec)
obclient(GISTAR@lnzyob)[GISTAR]> select count(*) from UPJUNCTION_BOX;
+----------+
| COUNT(*) |
+----------+
| 76961 |
+----------+
1 row in set (0.217 sec)
obclient(GISTAR@lnzyob)[GISTAR]>
obclient(GISTAR@lnzyob)[GISTAR]>
obclient(GISTAR@lnzyob)[GISTAR]> select distinct segment_name from user_segments where bytes>0 and segment_type='TABLE PARTITION' order by 1;
+---------------------------+
| SEGMENT_NAME |
+---------------------------+
| ADDRESSINFO |
| AN_ONU_MDF_CONN |
| AN_ONU_PORT |
| CABLE_CONNECTOR |
| CABLE_CONNECTOR_ROUTE |
| CUST_ADSL |
| CUST_CUSTOMER |
| CUST_ETHERNET |
| CUST_SERVICE |
| CUST_SERVICERELATIONSHIP |
| CUST_TELEPHONE |
| DA_ADSL_MDF_CONN |
| DA_ADSL_PORT |
| DA_CIR_IP_LN |
| DA_IP_PORT |
| DES_ADSL |
| DES_CONFIG_BILL |
| DES_CONFIG_RESULT |
| DES_CUSTOMER |
| DES_DESIGN_BILL |
| DES_ETHERNET |
| DES_LOGIC_RESOURCE |
| DES_PHYSICAL_NUMBER |
| DES_REQUEST |
| DES_RESOURCE_SEGMENT |
| DES_RESULT_CUSTOMER |
| DES_RESULT_SERVICE |
| DES_SERVICE |
| DES_SERVICEORDER_CUSTOMER |
| DES_SERVICEORDER_SERVICE |
| DES_SERVICE_CUR_RESULT |
| DES_SERVICE_USER_RELATION |
| DES_TELEPHONE |
| ELT_BOX_CONNECTOR |
| EQUIPMENT_ADDRESS |
| INSTANCEVAR |
| INTELNET_NBR |
| JUNCTIONBOX_ADDRESS |
| JUNCTION_BOX |
| MDF_CONNECTOR |
| MEASURE_ROUTE |
| NBR_LOG |
| PXPH_PON_ROUTE |
| SW_PORT |
| SW_TPORT_MTERM |
| TASK |
| TEL_NBR_BROADBAND |
| TEL_NBR_LOGIC |
| TEL_NBR_PHYSIC |
| TR_DDM_LOGIC_TERM |
| TR_DDM_TERM |
| TR_TPORT_DTERM |
| UPJUNCTION_BOX |
+---------------------------+
53 rows in set (0.028 sec)
obclient(GISTAR@lnzyob)[GISTAR]>
然后编辑脚本导入：
[root@ob ~]# pwd
/root
[root@ob ~]# head load.sh
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CABLE_CONNECTOR_ROUTE_DESIGN' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CABLE_CONNECTOR_ROUTE_HISTORY' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CUST_ACCOUNT' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CUST_DATALINK' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CUST_SERVICE_USER_RELATION' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CUST_SPECIALLINE' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'CUST_VAS' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'DA_BRAS_PORT' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'DA_CIR_IP_LN_HIS' -f /backup/2/ --skip-header
/root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.28 -P 2881 -u gistar -t lnzyob -p xxxxxx. --csv --table 'DA_CIR_IP_LN_HISTORY' -f /backup/2/ --skip-header
[root@ob ~]# nohup ./load.sh > ./load.log &
[root@ob ~]# tail -f load.log
