中文表名-导入导出-字符集

见到有人问关于中文表名的导入导出问题 ,随手作了一个实验。
其实我从不推荐使用中文表名,因为可能在导入导出、字符集设置、应用显示等方面存在问题,要想正确解决面对的所有问题,必然需要对Oracle相关知识具有相当的了解,否则只是徒增困扰而已。

这个实验之前,只是见过别人使用中文表名、字段名等,自己却是第一次尝试,万事都有第一次么。
1.用中文名建立一个测试表

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
...
DBSNMP
WMSYS

13 rows selected.

Elapsed: 00:00:00.00


2.exp导出数据
导出的时候需要注意客户端的字符集设置

[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
. ...
Export terminated successfully without warnings.


3.drop掉测试表

SQL> drop table 测试
2 /

Table dropped.

Elapsed: 00:00:00.36


4.imp导出数据

[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.


5.验证数据无误

SQL> select * from 测试; 

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
EYGLE
CSMIG
TEST
...
WMSYS

13 rows selected.

Elapsed: 00:00:00.01
SQL>


那么看来只要设置正确,也没有什么问题。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值