_FULL_01" completed with 1 error(s) at 16:24:48
查看表结构
[oracle@instsvr1 dumpdp]$ sqlplus vip/vip
SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 7 14:56:04 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
srcbdb@VIP> select * from tab where rownum <10;
TNAME TABTYPE CLUSTERID
------------------------------------------------------------ -------------- ----------
DISCARD_TBDSCLIENT TABLE
IT_AJDK TABLE
IT_DSDK TABLE
IT_DSDQCK TABLE
IT_DSHQCK TABLE
IT_DSKH TABLE
SNAPTBEXCHANGERATE TABLE
TBADVICELOG TABLE
TBADVICELOGSETMEAL TABLE
9 rows selected.
srcbdb@VIP> desc SNAPTBEXCHANGERATE
Name Null Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
MONEY_TYPE VARCHAR2(3) <-------------- 这说明表是以Byte存储VARCHAR2数据类型的。
TO_RMB_RATE NUMBER(15,7)
TO_USD_RATE NUMBER(15,7)
我们再新建一个表看一下,注意,不显示指定CHAR或者Byte,数据使用默认值!
结论:在11.2.0.1里面,对于使用imp/impdp工具导入的数据,nls_length_semantics不生效!
我不知道这是不是Oracle的Bug,看官也可以帮我求证一下!!!!
【附录:MOS上的文章】
Examples and limits of BYTE and CHAR semantics usage (NLS_LENGTH_SEMANTICS) [ID 144808.1]