ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 中文表名导入(二)

中文表名导入(二)

原创 Linux操作系统 作者:scorpions_z 时间:2011-09-03 14:13:57 0 删除 编辑

C:\Documents and Settings\Administrator>set NLS_LANG=AMERICAN

C:\Documents and Settings\Administrator>imp userid='sys/nc56 as sysdba'

file=D:\
chinese_tablename.dmp tables='测试表' ignore=y

Import: Release 10.2.0.3.0 - Production on Sat Sep 3 10:03:26 2011

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

- Produc
tion
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing SYS's objects into SYS
IMP-00033: Warning: Table "测试表" not found in export file
Import terminated successfully with warnings.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21104863/viewspace-706568/,如需转载,请注明出处,否则将追究法律责任。

下一篇: centos1
请登录后发表评论 登录
全部评论

注册时间:2009-03-13

  • 博文量
    6
  • 访问量
    4855