概述
[root@ybtb oradata]# cat impxbeis.log
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via direct path
Warning: the objects were exported by EIS, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table "MV_TAB_SITE" 1566405 rows imported
. . importing table "PLSQL_PROFILER_DATA" 396 rows imported
. . importing table "PLSQL_PROFILER_RUNS" 2 rows imported
. . importing table "PLSQL_PROFILER_UNITS" 4 rows imported
. . importing table "QUEST_SOO_AT_APPNAME" 0 rows imported
. . importing table "QUEST_SOO_AT_EXECUTION_PLAN" 0 rows imported
. . importing table "QUEST_SOO_AT_OPERATIONS" 0 rows imported
. . importing table "QUEST_SOO_AT_PARSE_CURSOR" 0 rows imported
. . importing table "QUEST_SOO_AT_PARSE_ERROR" 0 rows imported
. . importing table "QUEST_SOO_AT_PARSE_WAITS" 0 rows imported
. . importing table "QUEST_SOO_AT_SESSION_ID" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_BINDS" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_EXECUTIONS" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_EXEC_ERROR" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_FETCH" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_STATEMENT" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_STMT_PIECES" 0 rows imported
. . importing table "QUEST_SOO_AT_SQL_WAITS" 0 rows imported
. . importing table "QUEST_SOO_AT_TRACE_FILE" 0 rows imported
. . importing table "QUEST_SOO_AT_WAIT_NAMES" 0 rows imported
. . importing table "QUEST_SOO_BUFFER_BUSY" 0 rows imported
. . importing table "QUEST_SOO_EVENT_CATEGORIES" 1371 rows imported
. . importing table "QUEST_SOO_LOCK_TREE" 0 rows imported
. . importing table "QUEST_SOO_PARSE_TIME_TRACK" 1 rows imported
. . importing table "QUEST_SOO_PLAN_TABLE" 0 rows imported
. . importing table "QUEST_SOO_SB_BUFFER_BUSY" 0 rows imported
. . importing table "QUEST_SOO_SB_EVENT" 0 rows imported
. . importing table "QUEST_SOO_SB_IO_STAT" 0 rows imported
. . importing table "QUEST_SOO_SCHEMA_VERSIONS" 1 rows imported
. . importing table "QUEST_SOO_VERSION" 1 rows imported
. . importing table "QUICK_TABLE" 0 rows imported
. . importing table "SYS_EXPORT_SCHEMA_01" 1393 rows imported
. . importing table "SYS_IMPORT_FULL_01" 279 rows imported
. . importing table "SYS_IMPORT_FULL_02" 279 rows imported
. . importing table "SYS_IMPORT_FULL_03" 285 rows imported
. . importing table "SYS_IMPORT_FULL_04" 284 rows imported
. . importing table "SYS_IMPORT_FULL_05" 286 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201101" 0 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201102" 2151879 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201103" 99 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201104" 385 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201201" 160 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201202" 96 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201203" 195 rows imported
. . importing partition "TAB_ACCOUNT":"TAB_ACCOUNT_201204" 0 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201106" 101 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201108" 28 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201110" 9 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201112" 4 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201202" 0 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201204" 12 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201206" 3 rows imported
. . importing partition "TAB_ACCOUNT_SUB":"TAB_ACCOUNT_SUB_201208" 3 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P101" 107 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P102" 68 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P103" 50 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P104" 67 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P105" 87 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P106" 68 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P107" 82 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P108" 69 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P109" 56 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P110" 86 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P111" 76 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P112" 85 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P113" 55 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P114" 100 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P115" 98 rows imported
. . importing partition "TAB_ACCOUNT_TEMP":"SYS_P116" 67 rows imported
. . importing table "TAB_ACCOUNT_TEMP_SUB" 189 rows imported
. . importing table "TAB_ACCOUNT_TJ" 9 rows imported
. . importing table "TAB_APPLY_TO_UPDATE" 4058 rows imported
. . importing table "TAB_APPLY_TYPE" 6 rows imported
. . importing table "TAB_AREA" 0 rows imported
. . importing table "TAB_BF0316" 341 rows imported
. . importing table "TAB_BF_0316" 340 rows imported
. . importing table "TAB_BF_0317" 550 rows imported
. . importing table "TAB_BIGAREA" 3 rows imported
. . importing table "TAB_BILLINPUT_FORMATE" 323 rows imported
. . importing table "TAB_BILLSTATUS" 15 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P37" 12532 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P38" 12511 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P39" 12367 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P40" 12495 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P41" 12557 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P42" 12524 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P43" 12521 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P44" 12459 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P45" 12499 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P46" 12662 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P47" 12526 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P48" 12484 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P49" 12381 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P50" 12631 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P51" 12507 rows imported
. . importing partition "TAB_BRECEIPT":"SYS_P52" 12688 rows imported
. . importing table "TAB_BRECEIPT_STATUS" 0 rows imported
. . importing table "TAB_BUS" 0 rows imported
. . importing table "TAB_CASH_ACCOUNTING" 37 rows imported
. . importing table "TAB_CASH_ACCOUNT_SUM" 0 rows imported
. . importing table "TAB_CASH_ACCOUNT_TEMP" 28 rows imported
. . importing table "TAB_CASH_PAY_BALANCE" 18 rows imported
. . importing table "TAB_CENTER_RECI_PAY_REGISTER" 0 rows imported
. . importing partition "TAB_CHILD":"SYS_P53" 38830 rows imported
. . importing partition "TAB_CHILD":"SYS_P54" 39204 rows imported
. . importing partition "TAB_CHILD":"SYS_P55" 38879 rows imported
. . importing partition "TAB_CHILD":"SYS_P56" 38896 rows imported
. . importing partition "TAB_CHILD":"SYS_P57" 38973 rows imported
. . importing partition "TAB_CHILD":"SYS_P58" 38961 rows imported
. . importing partition "TAB_CHILD":"SYS_P59" 39130 rows imported
. . importing partition "TAB_CHILD":"SYS_P60" 39226 rows imported
. . importing partition "TAB_CHILD":"SYS_P61" 39176 rows imported
. . importing partition "TAB_CHILD":"SYS_P62" 38712 rows imported
. . importing partition "TAB_CHILD":"SYS_P63" 38821 rows imported
. . importing partition "TAB_CHILD":"SYS_P64" 39163 rows imported
. . importing partition "TAB_CHILD":"SYS_P65" 39106 rows imported
. . importing partition "TAB_CHILD":"SYS_P66" 38869 rows imported
. . importing partition "TAB_CHILD":"SYS_P67" 39109 rows imported
. . importing partition "TAB_CHILD":"SYS_P68" 39164 rows imported
. . importing table "TAB_COMMON_FUNCTION" 106 rows imported
. . importing table "TAB_CONTACT" 16 rows imported
. . importing table "TAB_CONTACT2" 0 rows imported
. . importing table "TAB_COSTTYPE" 3 rows imported
. . importing table "TAB_CURRENCY_TYPE" 3 rows imported
. . importing table "TAB_CUSTOMER" 3195 rows imported
. . importing table "TAB_DELIVERY" 2 rows imported
. . importing table "TAB_DEPARTMENT" 26 rows imported
. . importing table "TAB_DEPTRTX" 0 rows imported
. . importing table "TAB_DESTINATION" 1210 rows imported
. . importing table "TAB_DESTINATION_CCES" 1 rows imported
. . importing table "TAB_DIS_ADDRESS2SITE" 10 rows imported
. . importing table "TAB_DIS_AREA" 2 rows imported
. . importing table "TAB_DIS_ASSIGN" 4 rows imported
. . importing table "TAB_DIS_CITY" 2 rows imported
. . importing table "TAB_DIS_PROVINCE" 4 rows imported
. . importing table "TAB_DIS_SITE" 6 rows imported
. . importing table "TAB_EXCEL_FORMAT" 409 rows imported
. . importing table "TAB_EXPRESS_TYPE" 10 rows imported
. . importing table "TAB_FINANCE_REPORT" 316008 rows imported
. . importing table "TAB_FIXEDCOST" 0 rows imported
. . importing table "TAB_FIXEDDEDUCT_DETAIL" 0 rows imported
. . importing table "TAB_FLIGHTS" 0 rows imported
. . importing table "TAB_FREIGHT_CHANGE" 0 rows imported
. . importing table "TAB_FUNCTIONINFO" 761 rows imported
. . importing table "TAB_FUN_RUNTIME" 60410 rows imported
. . importing partition "TAB_GOODSMONEY":"TAB_GOODSMONEY_2011" 414295 rows imported
. . importing partition "TAB_GOODSMONEY":"TAB_GOODSMONEY_2012" 15 rows imported
. . importing table "TAB_GOODSMONEY0317_2" 8590 rows imported
. . importing table "TAB_GOODSMONEYRATE" 32 rows imported
. . importing table "TAB_GOODSMONEYRATE20110527" 17 rows imported
. . importing table "TAB_GOODSMONEYRATE_SUB" 2 rows imported
. . importing table "TAB_GOODSMONEY_0317" 2713 rows imported
. . importing table "TAB_GOODSMONEY_ACCOUNT_SUM" 0 rows imported
. . importing table "TAB_GOODSMONEY_CHANGE" 6245 rows imported
. . importing table "TAB_GOODSMONEY_CHANGE_SUB" 5 rows imported
. . importing table "TAB_GOODSMONEY_CUSTOMER" 5 rows imported
. . importing table "TAB_GOODSMONEY_DETAIL" 69247 rows imported
. . importing table "TAB_GOODSMONEY_DETAIL_SUB" 26 rows imported
. . importing table "TAB_GOODSMONEY_ERROR" 291 rows imported
. . importing table "TAB_GOODSMONEY_REPORT" 7053 rows imported
. . importing table "TAB_GOODSMONEY_SUB" 677 rows imported
. . importing table "TAB_GOODSMONEY_TEMP" 0 rows imported
. . importing table "TAB_GOODS_STATUS_FOLLOW" 1146972 rows imported
. . importing table "TAB_GPSDATE" 391 rows imported
. . importing table "TAB_HELP_INFO" 82 rows imported
. . importing table "TAB_HELP_KEYWORDS" 194 rows imported
. . importing table "TAB_HELP_LIST" 67 rows imported
. . importing table "TAB_JSONINFO" 3 rows imported
. . importing table "TAB_LC_TYPE" 11 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "TAB_LC_TYPE" TO "EIS_KL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_KL' does not exist
. . importing table "TAB_LINE" 3 rows imported
. . importing table "TAB_LOG" 359 rows imported
. . importing table "TAB_LOG_RECEIPT_CCES" 11 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201101" 2207582 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201102" 837216 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201103" 270 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201104" 217 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201201" 56 rows imported
. . importing partition "TAB_LOG_TABLE_OPERATION":"TAB_LOG_TABLE_OPERATION_201202" 233 rows imported
. . importing table "TAB_LOG_TAB_QUOTE" 0 rows imported
. . importing table "TAB_MATERIAL" 27 rows imported
. . importing table "TAB_MATERIAL_DISPOSE" 731 rows imported
. . importing table "TAB_MATTER_TYPE" 0 rows imported
. . importing table "TAB_MESSAGE" 127 rows imported
. . importing table "TAB_NETMASTER" 0 rows imported
. . importing table "TAB_NOTE_CONFIG" 0 rows imported
. . importing table "TAB_OPERATERATE" 2 rows imported
. . importing table "TAB_ORDER" 0 rows imported
. . importing table "TAB_ORDER_TEST" 69 rows imported
. . importing table "TAB_OVERSEE_PRAESCRIPTIO" 0 rows imported
. . importing table "TAB_PARAMETER_TYPE" 44 rows imported
. . importing table "TAB_PARTNER" 2 rows imported
. . importing table "TAB_PAYMANNER" 9 rows imported
. . importing table "TAB_PAY_METHOD" 2 rows imported
. . importing table "TAB_PDASTYLE" 25 rows imported
. . importing table "TAB_PREPAY_BALANCE" 441 rows imported
. . importing table "TAB_PREPAY_BALANCE0219" 414 rows imported
. . importing table "TAB_PREPAY_BALANCE_SUB" 9 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201101" 0 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201102" 0 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201103" 0 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201104" 779787 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201105" 92 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201106" 309 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201201" 155 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201202" 30 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201203" 33 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201204" 245 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201205" 0 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201206" 0 rows imported
. . importing partition "TAB_PREPAY_DETAIL":"TAB_PREPAY_DETAIL_201207" 0 rows imported
. . importing table "TAB_PREPAY_DETAIL_SUB" 269 rows imported
. . importing table "TAB_PREPAY_IMPORT" 33 rows imported
. . importing table "TAB_PREPAY_IMPORT22" 128 rows imported
. . importing table "TAB_PREPAY_IMPORT_CHECK" 51779 rows imported
. . importing table "TAB_PREPAY_IMPORT_SITE_CHECK" 0 rows imported
. . importing table "TAB_PREPAY_MODIFY" 5828 rows imported
. . importing table "TAB_PREPAY_SITE_APPLY" 95 rows imported
. . importing table "TAB_PREPAY_SITE_APPLY_MATE" 17 rows imported
. . importing table "TAB_PREPAY_SITE_APPLY_TAX" 14 rows imported
. . importing table "TAB_PREPAY_SUM" 0 rows imported
. . importing partition "TAB_PROBLEM":"TAB_PROBLEM_2011" 573343 rows imported
. . importing partition "TAB_PROBLEM":"TAB_PROBLEM_2012" 3 rows imported
. . importing table "TAB_PROBLEM_CCES" 2 rows imported
. . importing table "TAB_PROBLEM_PROCESS" 234580 rows imported
. . importing table "TAB_PROBLEM_PROCESS_CCES" 1 rows imported
. . importing table "TAB_PROBLEM_TYPE" 28 rows imported
. . importing table "TAB_PROVINCE" 149 rows imported
. . importing table "TAB_QUOTE" 244 rows imported
. . importing table "TAB_QUOTE20110815" 283 rows imported
. . importing table "TAB_QUOTE22" 261 rows imported
. . importing table "TAB_QUOTE_SUB" 9 rows imported
. . importing table "TAB_QUOTE_TEMP" 18 rows imported
. . importing table "TAB_REACH_MONEY_RATE" 0 rows imported
. . importing partition "TAB_RECEIPT":"TAB_RECEIPT_201101" 1488480 rows imported
. . importing partition "TAB_RECEIPT":"TAB_RECEIPT_201102" 77802 rows imported
. . importing partition "TAB_RECEIPT":"TAB_RECEIPT_201201" 249 rows imported
. . importing partition "TAB_RECEIPT":"TAB_RECEIPT_201202" 192 rows imported
. . importing table "TAB_RECEIPT_CCES" 32 rows imported
. . importing table "TAB_RECEIPT_HISTORY" 0 rows imported
. . importing table "TAB_RECEIPT_PROCESS" 1 rows imported
. . importing table "TAB_RECEIPT_TEMP" 35 rows imported
. . importing table "TAB_RECEIPT_TEMP2" 0 rows imported
. . importing table "TAB_RECEIVE_TEMP" 7 rows imported
. . importing table "TAB_RECHARGE_REFUND" 0 rows imported
. . importing table "TAB_REGION" 166 rows imported
. . importing table "TAB_REGIONMANAGE" 11 rows imported
. . importing table "TAB_ROLEINFO" 7477 rows imported
. . importing table "TAB_ROLE_WARNING" 21 rows imported
. . importing table "TAB_RTX" 45 rows imported
. . importing table "TAB_RTXDEPT" 2 rows imported
. . importing table "TAB_SAMECITY" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201101" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201102" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201103" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201104" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201105" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201106" 0 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201107" 92009 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201108" 1 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201109" 50 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201110" 13007 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201111" 18 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201112" 5 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201206" 42 rows imported
. . importing partition "TAB_SCAN":"TAB_SCAN_201207" 78 rows imported
. . importing table "TAB_SCANRATE_BASE" 8 rows imported
. . importing table "TAB_SCANRATE_DETAIL" 1186 rows imported
. . importing table "TAB_SCAN_BRECEIPT" 540011 rows imported
. . importing table "TAB_SCAN_BRECEIPT_TEMP" 1 rows imported
. . importing table "TAB_SCAN_CCES" 2 rows imported
. . importing table "TAB_SCAN_COLLECT" 2 rows imported
. . importing table "TAB_SCAN_FACTOR" 9409367 rows imported
. . importing table "TAB_SCAN_HISTORY" 2 rows imported
. . importing table "TAB_SCAN_HISTORY3" 5 rows imported
. . importing table "TAB_SCAN_INPUTCOMPARE" 828 rows imported
. . importing table "TAB_SCAN_PRAESCRIPTIO" 1 rows imported
. . importing table "TAB_SCAN_PROBLEM" 1 rows imported
. . importing table "TAB_SCAN_PROBLEM_TEMP" 1 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201104" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201105" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201106" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201107" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201108" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201109" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201110" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201111" 0 rows imported
. . importing partition "TAB_SCAN_TEST":"TAB_SCAN_TEST_201112" 0 rows imported
. . importing table "TAB_SCHEDULE" 3 rows imported
. . importing table "TAB_SENDBILLSEARCH_TEMP" 0 rows imported
. . importing table "TAB_SERVICESTYLE" 2 rows imported
. . importing partition "TAB_SIGNIN":"TAB_SIGNIN_2011" 1390536 rows imported
. . importing partition "TAB_SIGNIN":"TAB_SIGNIN_2012" 134 rows imported
. . importing table "TAB_SIGNIN_CCES" 2 rows imported
. . importing table "TAB_SIGNIN_PRAESCRIPTIO" 5 rows imported
. . importing table "TAB_SIGNIN_TEMP" 25 rows imported
. . importing table "TAB_SITE" 729 rows imported
. . importing table "TAB_SITE0312" 571 rows imported
. . importing table "TAB_SITE_20120210_BAK" 600 rows imported
. . importing table "TAB_SITE_20120215" 571 rows imported
. . importing table "TAB_SITE_BAK" 0 rows imported
. . importing partition "TAB_SITE_FIN_CANCEL":"TAB_FIN_CANCEL_2011" 623155 rows imported
. . importing partition "TAB_SITE_FIN_CANCEL":"TAB_FIN_CANCEL_2012" 120 rows imported
. . importing table "TAB_SITE_FIN_CANCEL_SUM" 0 rows imported
. . importing table "TAB_SITE_MONITOR" 315 rows imported
. . importing table "TAB_SITE_MONTH_DETAIL" 61133 rows imported
. . importing table "TAB_SITE_MONTH_SUM" 4 rows imported
. . importing table "TAB_SITE_OVERSEE_STATISTICS" 0 rows imported
. . importing table "TAB_SITE_STATISTICS_TEMP" 0 rows imported
. . importing table "TAB_SITE_SUB" 10 rows imported
. . importing table "TAB_SJJKXX" 1232 rows imported
. . importing table "TAB_SMS_DETAIL" 0 rows imported
. . importing table "TAB_SMS_SENDSMS" 1325 rows imported
. . importing table "TAB_STAFFDATA" 121 rows imported
. . importing table "TAB_STAFF_COLLECT" 25 rows imported
. . importing table "TAB_STAFF_COLLECT_SUM" 15 rows imported
. . importing table "TAB_STAFF_DEDUCT" 21 rows imported
. . importing table "TAB_STAFF_DEDUCT_DETAIL" 6876 rows imported
. . importing table "TAB_STAFF_DEDUCT_SUM" 11 rows imported
. . importing table "TAB_STAFF_TYPE" 10 rows imported
. . importing table "TAB_SURVEY" 14 rows imported
. . importing table "TAB_SURVEY_STAT" 4 rows imported
. . importing table "TAB_TABLEMEDATA" 0 rows imported
. . importing table "TAB_TB_COLLECT_FAIL" 4745 rows imported
. . importing table "TAB_TB_CUSTOMER_SITE" 15246 rows imported
. . importing table "TAB_TB_FAIL_REASON" 20 rows imported
. . importing table "TAB_TB_GOODS_INFO" 84655 rows imported
. . importing table "TAB_TB_ORDER" 44983 rows imported
. . importing table "TAB_TB_ORDER0317" 2953 rows imported
. . importing table "TAB_TB_ORDER_STATUS" 213926 rows imported
. . importing table "TAB_TB_ORDER_TEMP" 42576 rows imported
. . importing table "TAB_TB_PROVINCE_CITY" 36 rows imported
. . importing table "TAB_TB_PROVINCE_SITE" 552 rows imported
. . importing table "TAB_TELECOM" 1198 rows imported
. . importing table "TAB_TELECOM_BAGDETAIL" 53048 rows imported
. . importing table "TAB_TELECOM_BAGS" 15751 rows imported
. . importing table "TAB_TELECOM_BAGS_TEMP" 2344 rows imported
. . importing table "TAB_TELECOM_DIS" 26020 rows imported
. . importing table "TAB_TELECOM_ORDER" 484 rows imported
. . importing table "TAB_TELECOM_ORD_BAGS" 1109 rows imported
. . importing table "TAB_TELECOM_ORD_UIM" 960 rows imported
. . importing table "TAB_TELECOM_STATUS" 3902 rows imported
. . importing table "TAB_TELECOM_STORAGE" 72197 rows imported
. . importing table "TAB_TELECOM_SUM" 1031 rows imported
. . importing table "TAB_TELECOM_WAREHOUSE" 0 rows imported
. . importing table "TAB_TEMP" 6164 rows imported
. . importing table "TAB_TEST_TJ" 52 rows imported
. . importing table "TAB_TOPAYRATE" 11 rows imported
. . importing table "TAB_UP_PRAESCRIPTION" 21873 rows imported
. . importing table "TAB_URGE_SEND_EXPRESS" 785 rows imported
. . importing table "TAB_USER" 59 rows imported
. . importing table "TAB_USERINFO" 1930 rows imported
. . importing table "TAB_USERROLE" 2641 rows imported
. . importing table "TAB_WARNING_PATH" 9 rows imported
. . importing table "TAB_WEIGHT_BLOCK" 10 rows imported
. . importing table "TAB_WEIGHT_STATISTICS_TEMP" 90 rows imported
. . importing table "TAB_WORKLOG" 20 rows imported
. . importing table "TAB_rtx" 0 rows imported
. . importing table "TAB_通用报价表" 261 rows imported
. . importing table "TB_COMMON_BILLING" 1683 rows imported
. . importing table "TB_COMMON_COLLECTMONEY" 16247 rows imported
. . importing table "TB_COMMON_DEPT" 594 rows imported
. . importing table "TB_COMMON_ETLTIME" 0 rows imported
. . importing table "TB_COMMON_GPS_TRACE" 2987 rows imported
. . importing table "TB_COMMON_LOG" 445344 rows imported
. . importing table "TB_COMMON_ORDER" 0 rows imported
. . importing table "TB_COMMON_ORDERSTATE" 31428 rows imported
. . importing table "TB_COMMON_OTHERPRICE" 2223 rows imported
. . importing table "TB_COMMON_PARTNER" 2 rows imported
. . importing table "TB_COMMON_PRICE" 8614 rows imported
. . importing table "TB_COMMON_RECEIVE_TEMP" 0 rows imported
. . importing table "TB_COMMON_SIGNORDER" 811 rows imported
. . importing table "TB_COMMON_TRACE" 1924 rows imported
. . importing table "TB_MAXTIME" 0 rows imported
. . importing table "TEMP_COUNT" 227 rows imported
. . importing table "TEST" 0 rows imported
. . importing table "TEST2" 4 rows imported
. . importing table "TESTC" 252 rows imported
. . importing table "TEST_COMMON_ORDER" 11 rows imported
. . importing table "TEST_SQLPARSE" 1640 rows imported
. . importing table "TEST_STANDBY" 5 rows imported
. . importing table "TEST_STANDBY2" 2 rows imported
. . importing table "T_ACC_CHK_CANCEL_DETAIL" 39133 rows imported
. . importing table "T_ACC_RECEIVE" 331536 rows imported
. . importing table "T_ORDER_INFO" 11 rows imported
. . importing table "T_TEMP" 130 rows imported
. . importing table "T_TEST2" 4764 rows imported
. . importing table "T_TEST5" 0 rows imported
. . importing table "T_TEST8" 9999 rows imported
. . importing table "USERTABLE" 1 rows imported
. . importing table "WEI_USER" 3 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "V_WB_SITE" TO "EIS_KL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_KL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "V_WB_STAFFDATA" TO "EIS_KL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_KL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "VI_KL_PDA" TO "EIS_KL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_KL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "VI_PDA_USER" TO "EIS_KL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_KL' does not exist
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"EIS"', '"BIN$mggPtvohdPDgQAl"
"5CNRh3w==$0"', FALSE); END;"
IMP-00003: ORACLE error 23308 encountered
ORA-23308: object EIS.BIN$mggPtvohdPDgQAl5CNRh3w==$0 does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 335
ORA-06512: at line 1
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "XBEIS".trg_common_order"
"before insert on TB_COMMON_ORDER"
"for each row"
"declare no number;"
"begin"
" select seq_order.nextval into no from dual;"
" :new.orderid:='CM'||to_char(sysdate,'yymmdd')||trim(to_char(no,'00000'))"
";"
"end;"
""
"select seq_order.nextval from dual;"
""
"----------重置序列号的存储过程(每天凌晨会被调用)"
"create or replace procedure seq_order_reset(seq_order varchar2) as"
" n number(10);"
" tsql varchar2(100);"
"begin"
" execute immediate 'select ' || seq_order || '.nextval from dual'"
" into n;"
" n:= - (n - 1);"
" tsql:= 'alter sequence ' || seq_order || ' increment by ' || n;"
" execute immediate tsql;"
" execute immediate 'select ' || seq_order || '.nextval from dual'"
" into n;"
" tsql:= 'alter sequence ' || seq_order || ' increment by 1';"
" execute immediate tsql;"
"end seq_order_reset;"
IMP-00017: following statement failed with ORACLE error 23401:
"BEGIN dbms_refresh.add(name=>'"EIS"."MV_TAB_SITE"',list=>'"EIS"."MV_TAB_S"
"ITE"',siteid=>0,export_db=>'YBDB'); END;"
IMP-00003: ORACLE error 23401 encountered
ORA-23401: materialized view "EIS"."MV_TAB_SITE" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_IREFRESH", line 159
ORA-06512: at "SYS.DBMS_IREFRESH", line 824
ORA-06512: at "SYS.DBMS_REFRESH", line 139
ORA-06512: at "SYS.DBMS_REFRESH", line 125
ORA-06512: at line 1
Import terminated successfully with warnings.
最后
以上就是酷酷芝麻为你收集整理的oracle导入+警告,exp导入数据成功,但出现警告,应该怎么处理的全部内容,希望文章能够帮你解决oracle导入+警告,exp导入数据成功,但出现警告,应该怎么处理所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复