是不是原因字符集

missroad20

从其它数据库备份出来的dmp,导入到本数据库时发现所有的表名为中文的表都没有导进来,而且如果存储过程中用到中文表时,导过来时表名变为????,乱码!
同样的道理如果从本机导出dmp,如果表名为中文的话,导的时候显示为I_????(本来为I_光缆接头),这些表根本导不出来!
用select  *  from  V$NLS_PARAMETERS;查看发现:
NLS_LANGUAGE------AMERICAN,
NLS_TERRITORY----AMERICA,
NLS_DATE_LANGUAGE---AMERICAN,
而
NLS_CHARACTERSET却是ZHS16GBK,
总觉得有点不对!
请问各位大哥大姐这个问题如何解决!不胜感激!
谢谢!
紧急!

zflying2000

查看一下备份文件的文件头。或者你的导入日志应该可以看出来原来的数据库字符集！

missroad2004

我看了一下备份日志!是这样的:
连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
那是不是说我用的备份的dmp文件字符集是ZHS16GBK ,与我现在的是一样啊!为什么中文表名导不进去!

eygle

不建议使用中文表名，俺是从来没有用过
不过测试一下也是没有问题的，请看

[PHP]
SQL> create table 测试 as select username from dba_users;

Table created.

Elapsed: 00:00:00.08
SQL> select * from 测试;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
EYGLE
CSMIG
TEST
REPADMIN
SCOTT
CJH
CJWEE
MLQIN

USERNAME
------------------------------
DBSNMP
WMSYS

13 rows selected.

Elapsed: 00:00:00.00
SQL> !
[oracle@jumper oracle]$ exp eygle/eygle file=a.dmp         

Export: Release 9.2.0.4.0 - Production on Tue Oct 18 10:58:24 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user EYGLE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EYGLE
About to export EYGLE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export EYGLE's tables via Conventional Path ...
. . exporting table                     PLAN_TABLE          0 rows exported
. . exporting table                             T1          5 rows exported
. . exporting table                             T2         13 rows exported
. . exporting table                           测试         13 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@jumper oracle]$ exit
exit

SQL> drop table 测试
  2  /

Table dropped.

Elapsed: 00:00:00.36
SQL> ！
SP2-0042: unknown command "！" - rest of line ignored.
SQL> !
[oracle@jumper oracle]$ imp eygle/eygle file=a.dmp tables=测试

Import: Release 9.2.0.4.0 - Production on Tue Oct 18 10:59:03 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing EYGLE's objects into EYGLE
. . importing table                         "测试"         13 rows imported
Import terminated successfully without warnings.
[oracle@jumper oracle]$ exit
exit

SQL> select * from 测试;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
EYGLE
CSMIG
TEST
REPADMIN
SCOTT
CJH
CJWEE
MLQIN

USERNAME
------------------------------
DBSNMP
WMSYS

13 rows selected.

Elapsed: 00:00:00.01
SQL>

[/PHP]