加载中…
个人资料
微博
  • 博客等级：
  • 博客积分：
  • 博客访问：
  • 关注人气：
  • 获赠金笔：0支
  • 赠出金笔：0支
  • 荣誉徽章：
正文 字体大小：大 中 小

Oracle Database Export with AL32UTF8&Import with UTF8-3

(2013-03-06 15:21:28)
标签：

it

 分类： Oracle DBA
Imp log with UTF8 dmp.txt
-----------------------------------------------
PAYDB-> echo $NLS_LANG
American_America.UTF8
PAYDB-> 
PAYDB-> 
PAYDB-> 
PAYDB-> imp yeexing/xxxxxx fromuser=yeexing touser=yeexing file=/oradata/backup/exp_airtrip_yeexing.dmp log=/oradata/exp_airtrip_yeexing.log

Import: Release 10.2.0.5.0 - Production on Wed Mar 6 14:26:03 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. . importing table             "TIPS_ACC_BALANCE"      19768 rows imported
. . importing table        "TIPS_ACC_BALANCEQUEUE"          0 rows imported
. . importing table              "TIPS_BS_BALTYPE"          8 rows imported
. . importing table                 "TIPS_BS_BANK"         34 rows imported
. . importing table             "TIPS_BS_BANKCARD"         83 rows imported
. . importing table                  "TIPS_BS_BBC"          0 rows imported
. . importing table          "TIPS_BS_DAILYCONFIG"        108 rows imported
. . importing table               "TIPS_BS_DEPART"          3 rows imported
. . importing table               "TIPS_BS_DPBANK"         64 rows imported
. . importing table            "TIPS_BS_GEOGRAPHY"        443 rows imported
. . importing table                "TIPS_BS_GROUP"          4 rows imported
. . importing table            "TIPS_BS_GROUPBANK"         78 rows imported
. . importing table             "TIPS_BS_HEADSHIP"          0 rows imported
. . importing table              "TIPS_BS_MANAGER"         16 rows imported
. . importing table           "TIPS_BS_SETTLEBANK"         21 rows imported
. . importing table                 "TIPS_BS_TYPE"          3 rows imported
. . importing table          "TIPS_CHK_CHECKTRADE"         17 rows imported
. . importing table          "TIPS_CHK_DAILYCHECK"          0 rows imported
. . importing table               "TIPS_DAILY_LOG"         12 rows imported
. . importing table                "TIPS_DATA_LOG"          0 rows imported
. . importing table             "TIPS_FNC_BALANCE"     170856 rows imported
. . importing table         "TIPS_FNC_CALCBALANCE"      90045 rows imported
. . importing table        "TIPS_FNC_DAILYBALANCE"    4898221 rows imported
. . importing table         "TIPS_FNC_DAILYRECORD"      22595 rows imported
. . importing table            "TIPS_FNC_ENDOFDAY"          0 rows imported
. . importing table              "TIPS_FNC_FREEZE"     170856 rows imported
. . importing table        "TIPS_GROUP_FEEACCOUNT"          1 rows imported
. . importing table               "TIPS_GROUP_RSA"          1 rows imported
. . importing table          "TIPS_GRP_AUTORBTYPE"          0 rows imported
. . importing table              "TIPS_GRP_CONFIG"          5 rows imported
. . importing table     "TIPS_HEADSHIP_PERMISSION"          0 rows imported
. . importing table                     "TIPS_LOG"          0 rows imported
. . importing table      "TIPS_MANAGER_PERMISSION"       2392 rows imported
. . importing table "TIPS_MANAGER_PERMISSION_TEMP"          0 rows imported
. . importing table                "TIPS_MAN_COPY"          4 rows imported
. . importing table     "TIPS_MAN_COPY_PERMISSION"          0 rows imported
. . importing table   "TIPS_MAN_CUSTOM_PERMISSION"          0 rows imported
. . importing table           "TIPS_MER_AUTOCHECK"          0 rows imported
. . importing table             "TIPS_MER_BALTYPE"         16 rows imported
. . importing table             "TIPS_MER_CONFURL"          0 rows imported
. . importing table        "TIPS_MER_ISKEYACCOUNT"         24 rows imported
. . importing table             "TIPS_MER_MANAGER"         73 rows imported
. . importing table             "TIPS_MER_MAPPING"         43 rows imported
. . importing table              "TIPS_MER_MARGIN"          0 rows imported
. . importing table            "TIPS_MER_MERCHANT"       6521 rows imported
. . importing table         "TIPS_MER_PASSWORDPRE"         39 rows imported
. . importing table          "TIPS_MER_PERMISSION"          0 rows imported
. . importing table               "TIPS_MER_RATIO"         12 rows imported
. . importing table        "TIPS_MER_SETTLECONFIG"       4680 rows imported
. . importing table           "TIPS_MER_SETTLEPRE"        247 rows imported

. . importing table         "TIPS_MER_SETTLE_RULE"          0 rows imported
. . importing table   "TIPS_MER_SETTLE_RULE_CHECK"          0 rows imported
. . importing table          "TIPS_MER_SETTLE_SUM"         80 rows imported
. . importing table         "TIPS_MOV_ACC_ACCOUNT"       4538 rows imported
. . importing table     "TIPS_MOV_ACC_ACCOUNTTEMP"        701 rows imported
. . importing table        "TIPS_MOV_MER_MERCHANT"       1284 rows imported
. . importing table            "TIPS_MOV_USR_INFO"       3254 rows imported
. . importing table               "TIPS_PRI_GROUP"          3 rows imported
. . importing table           "TIPS_PRI_KEYCONFIG"         20 rows imported
. . importing table            "TIPS_PRI_MERCHANT"       6519 rows imported
. . importing table           "TIPS_PRI_PRICONFIG"          3 rows imported
. . importing table           "TIPS_PROCEDURE_LOG"          0 rows imported
. . importing table       "TIPS_SYSMAN_PERMISSION"        272 rows imported
. . importing table         "TIPS_SYSTEM_RESOURCE"        175 rows imported
. . importing table     "TIPS_SYSTEM_RESOURCE_BAK"          0 rows imported
. . importing table "TIPS_SYSTEM_RESOURCE_BAK100310"          0 rows imported
. . importing table  "TIPS_SYSTEM_RESOURCE_BLUERY"          0 rows imported
. . importing table                  "TIPS_TRD_AF"          0 rows imported
. . importing table                  "TIPS_TRD_AJ"       1459 rows imported
. . importing table                  "TIPS_TRD_AT"          0 rows imported
. . importing table            "TIPS_TRD_ATATTACH"          0 rows imported
. . importing table            "TIPS_TRD_BUSINESS"         12 rows imported
. . importing table                  "TIPS_TRD_CT"          0 rows imported
. . importing table                  "TIPS_TRD_DE"          0 rows imported
. . importing table                  "TIPS_TRD_DP"       7624 rows imported
. . importing table                  "TIPS_TRD_DT"      28870 rows imported
. . importing table            "TIPS_TRD_DTCONFIG"          1 rows imported
. . importing table              "TIPS_TRD_DTROLE"      20126 rows imported
. . importing table                  "TIPS_TRD_FZ"       3589 rows imported
. . importing table            "TIPS_TRD_FZDETAIL"       3603 rows imported
. . importing table                  "TIPS_TRD_HK"          0 rows imported
. . importing table                "TIPS_TRD_LOCK"      13337 rows imported
. . importing table                  "TIPS_TRD_NT"      20126 rows imported
. . importing table            "TIPS_TRD_NTATTACH"      20126 rows imported
. . importing table                  "TIPS_TRD_PF"       1314 rows imported
. . importing table                  "TIPS_TRD_RB"          0 rows imported
. . importing table                  "TIPS_TRD_RC"          0 rows imported
. . importing table              "TIPS_TRD_REDUCT"          0 rows imported
. . importing table                  "TIPS_TRD_RF"       2427 rows imported
. . importing table              "TIPS_TRD_RFAUTO"          0 rows imported
. . importing table                  "TIPS_TRD_RP"          0 rows imported
. . importing table                  "TIPS_TRD_RT"       5310 rows imported
. . importing table                  "TIPS_TRD_ST"       1295 rows imported
. . importing table            "TIPS_TRD_ST_CHECK"       1368 rows imported
. . importing table                  "TIPS_TRD_TF"         12 rows imported
. . importing table            "TIPS_TRD_TF_CHECK"         15 rows imported
. . importing table                  "TIPS_TRD_TI"      31456 rows imported
. . importing table            "TIPS_TRD_TI_CHECK"         80 rows imported
Import terminated successfully without warnings.


Imp log with AL32UTF8 dmp.txt
----------------------------------------------------
PAYDB-> echo $NLS_LANG
American_America.UTF8

PAYDB-> imp yeexing/xxxxx fromuser=yeexing touser=yeexing file=/oradata/backup/exp_airtrip_yeexing2.dmp log=/oradata/exp_airtrip_yeexing.log

Import: Release 10.2.0.5.0 - Production on Wed Mar 6 14:40:54 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
export client uses AL32UTF8 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. . importing table             "TIPS_ACC_BALANCE"      19768 rows imported
. . importing table        "TIPS_ACC_BALANCEQUEUE"          0 rows imported
. . importing table              "TIPS_BS_BALTYPE"          8 rows imported
. . importing table                 "TIPS_BS_BANK"         34 rows imported
. . importing table             "TIPS_BS_BANKCARD"         83 rows imported
. . importing table                  "TIPS_BS_BBC"          0 rows imported
. . importing table          "TIPS_BS_DAILYCONFIG"        108 rows imported
. . importing table               "TIPS_BS_DEPART"          3 rows imported
. . importing table               "TIPS_BS_DPBANK"         64 rows imported
. . importing table            "TIPS_BS_GEOGRAPHY"        443 rows imported
. . importing table                "TIPS_BS_GROUP"          4 rows imported
. . importing table            "TIPS_BS_GROUPBANK"         78 rows imported
. . importing table             "TIPS_BS_HEADSHIP"          0 rows imported
. . importing table              "TIPS_BS_MANAGER"         16 rows imported
. . importing table           "TIPS_BS_SETTLEBANK"         21 rows imported
. . importing table                 "TIPS_BS_TYPE"          3 rows imported
. . importing table          "TIPS_CHK_CHECKTRADE"         17 rows imported
. . importing table          "TIPS_CHK_DAILYCHECK"          0 rows imported
. . importing table               "TIPS_DAILY_LOG"         12 rows imported
. . importing table                "TIPS_DATA_LOG"          0 rows imported
. . importing table             "TIPS_FNC_BALANCE"     170856 rows imported
. . importing table         "TIPS_FNC_CALCBALANCE"      90045 rows imported
. . importing table        "TIPS_FNC_DAILYBALANCE"
    4898221 rows imported
. . importing table         "TIPS_FNC_DAILYRECORD"      22595 rows imported
. . importing table            "TIPS_FNC_ENDOFDAY"          0 rows imported
. . importing table              "TIPS_FNC_FREEZE"     170856 rows imported
. . importing table        "TIPS_GROUP_FEEACCOUNT"          1 rows imported
. . importing table               "TIPS_GROUP_RSA"          1 rows imported
. . importing table          "TIPS_GRP_AUTORBTYPE"          0 rows imported
. . importing table              "TIPS_GRP_CONFIG"          5 rows imported
. . importing table     "TIPS_HEADSHIP_PERMISSION"          0 rows imported
. . importing table                     "TIPS_LOG"          0 rows imported
. . importing table      "TIPS_MANAGER_PERMISSION"       2392 rows imported
. . importing table "TIPS_MANAGER_PERMISSION_TEMP"          0 rows imported
. . importing table                "TIPS_MAN_COPY"          4 rows imported
. . importing table     "TIPS_MAN_COPY_PERMISSION"          0 rows imported
. . importing table   "TIPS_MAN_CUSTOM_PERMISSION"          0 rows imported
. . importing table           "TIPS_MER_AUTOCHECK"          0 rows imported
. . importing table             "TIPS_MER_BALTYPE"         16 rows imported
. . importing table             "TIPS_MER_CONFURL"          0 rows imported
. . importing table        "TIPS_MER_ISKEYACCOUNT"         24 rows imported
. . importing table             "TIPS_MER_MANAGER"         73 rows imported
. . importing table             "TIPS_MER_MAPPING"         43 rows imported
. . importing table              "TIPS_MER_MARGIN"          0 rows imported
. . importing table            "TIPS_MER_MERCHANT"       6521 rows imported
. . importing table         "TIPS_MER_PASSWORDPRE"         39 rows imported
. . importing table          "TIPS_MER_PERMISSION"          0 rows imported
. . importing table               "TIPS_MER_RATIO"         12 rows imported
. . importing table        "TIPS_MER_SETTLECONFIG"       4680 rows imported
. . importing table           "TIPS_MER_SETTLEPRE"        247 rows imported
. . importing table         "TIPS_MER_SETTLE_RULE"          0 rows imported
. . importing table   "TIPS_MER_SETTLE_RULE_CHECK"          0 rows imported
. . importing table          "TIPS_MER_SETTLE_SUM"         80 rows imported
. . importing table         "TIPS_MOV_ACC_ACCOUNT"       4538 rows imported
. . importing table     "TIPS_MOV_ACC_ACCOUNTTEMP"        701 rows imported
. . importing table        "TIPS_MOV_MER_MERCHANT"       1284 rows imported
. . importing table            "TIPS_MOV_USR_INFO"       3254 rows imported
. . importing table               "TIPS_PRI_GROUP"          3 rows imported
. . importing table           "TIPS_PRI_KEYCONFIG"         20 rows imported
. . importing table            "TIPS_PRI_MERCHANT"       6519 rows imported
. . importing table           "TIPS_PRI_PRICONFIG"          3 rows imported
. . importing table           "TIPS_PROCEDURE_LOG"          0 rows imported
. . importing table       "TIPS_SYSMAN_PERMISSION"        272 rows imported
. . importing table         "TIPS_SYSTEM_RESOURCE"        175 rows imported
. . importing table     "TIPS_SYSTEM_RESOURCE_BAK"          0 rows imported
. . importing table "TIPS_SYSTEM_RESOURCE_BAK100310"          0 rows imported
. . importing table  "TIPS_SYSTEM_RESOURCE_BLUERY"          0 rows imported
. . importing table                  "TIPS_TRD_AF"          0 rows imported
. . importing table                  "TIPS_TRD_AJ"       1459 rows imported
. . importing table                  "TIPS_TRD_AT"          0 rows imported
. . importing table            "TIPS_TRD_ATATTACH"          0 rows imported
. . importing table            "TIPS_TRD_BUSINESS"         12 rows imported
. . importing table                  "TIPS_TRD_CT"          0 rows imported
. . importing table                  "TIPS_TRD_DE"          0 rows imported
. . importing table                  "TIPS_TRD_DP"       7624 rows imported
. . importing table                  "TIPS_TRD_DT"      28870 rows imported
. . importing table            "TIPS_TRD_DTCONFIG"          1 rows imported
. . importing table              "TIPS_TRD_DTROLE"      20126 rows imported
. . importing table                  "TIPS_TRD_FZ"       3589 rows imported
. . importing table            "TIPS_TRD_FZDETAIL"       3603 rows imported
. . importing table                  "TIPS_TRD_HK"          0 rows imported
. . importing table                "TIPS_TRD_LOCK"      13337 rows imported
. . importing table                  "TIPS_TRD_NT"      20126 rows imported
. . importing table            "TIPS_TRD_NTATTACH"      20126 rows imported
. . importing table                  "TIPS_TRD_PF"       1314 rows imported
. . importing table                  "TIPS_TRD_RB"          0 rows imported
. . importing table                  "TIPS_TRD_RC"          0 rows imported
. . importing table              "TIPS_TRD_REDUCT"          0 rows imported
. . importing table                  "TIPS_TRD_RF"       2427 rows imported
. . importing table              "TIPS_TRD_RFAUTO"          0 rows imported
. . importing table                  "TIPS_TRD_RP"          0 rows imported
. . importing table                  "TIPS_TRD_RT"       5310 rows imported
. . importing table                  "TIPS_TRD_ST"       1295 rows imported
. . importing table            "TIPS_TRD_ST_CHECK"       1368 rows imported
. . importing table                  "TIPS_TRD_TF"         12 rows imported
. . importing table            "TIPS_TRD_TF_CHECK"         15 rows imported
. . importing table                  "TIPS_TRD_TI"      31456 rows imported
. . importing table            "TIPS_TRD_TI_CHECK"         80 rows imported
Import terminated successfully without warnings.

喜欢

0

阅读┊ 收藏 ┊ 喜欢▼ ┊打印┊举报/Report
  

新浪BLOG意见反馈留言板　欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

Copyright © 1996 - 2022 SINA Corporation, All Rights Reserved

新浪公司 版权所有