中文表名导入（二）

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21104863/viewspace-706568/