[20191219]索引名里带回车符.txt

[20191219]索引名里带回车符.txt --//链接http://www.itpub.net/thread-2123029-1-1.html提到的问题,索引名里带回车符,自己测试一下,如何改名: 1.环境: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SCOTT@book> create table t as select rownum id ,lpad('x',100,'x') name ,lpad('1',1) flag from dual connect by level<=1e5; Table created. 2.首先遇到的问题,怎么建立1个索引名里面带回车符: --//在toad下输入如下:  create index "i_t_  id" on t(id); --//实际上在sqlplus也可以: SCOTT@book> create index "i_t_   2  name " on t(name); Index created. SCOTT@book> select dump(index_name,16) c50 ,index_name,index_type,blevel,leaf_blocks,distinct_keys from dba_indexes where owner=user and table_name='T'; C50                                        INDEX_NAME INDEX_TYPE BLEVEL LEAF_BLOCKS DISTINCT_KEYS ------------------------------------------ ---------- ---------- ------ ----------- ------------- Typ=1 Len=8: 69,5f,74,5f,a,20,69,64        i_t_       NORMAL          1         222        100000                                             id Typ=1 Len=10: 69,5f,74,5f,a,6e,61,6d,65,20 i_t_       NORMAL          2        1563             1                                            name --//确定使用instr(index_name,chr(10))>0. SCOTT@book> select dump(index_name,16) c50 ,index_name,index_type,blevel,leaf_blocks,distinct_keys from dba_indexes where owner=user  and instr(index_name,chr(10))>0; C50                                        INDEX_NAME INDEX_TYPE BLEVEL LEAF_BLOCKS DISTINCT_KEYS ------------------------------------------ ---------- ---------- ------ ----------- ------------- Typ=1 Len=8: 69,5f,74,5f,a,20,69,64        i_t_       NORMAL          1         222        100000                                             id Typ=1 Len=10: 69,5f,74,5f,a,6e,61,6d,65,20 i_t_       NORMAL          2        1563             1                                            name 3.改名: --//如果不多,直接在toad下修改,跟踪实际上执行如下: alter index "SCOTT"."i_t_  id" rename to I_T_ID --//实际上如果不多解决并不太复杂.