ORA-30556错误
来源:互联网 发布:2016年淘宝商家数量 编辑:程序博客网 时间:2024/05/22 08:49
SQL> CREATE TABLE TEST2 (A NUMBER(9,0), B VARCHAR2(20) not null);
Table created.
SQL> CREATE INDEX test2index1 ON test2(UPPER(B));
Index created.
SQL> alter table TEST2 modify B VARCHAR2(24);
alter table TEST2 modify B VARCHAR2(24)
*
ERROR at line 1:
ORA-30556: functional index is defined on the column to be modified
SQL> select * from user_ind_columns where table_name='TEST2';
INDEX_NAME TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------ ------------------
TEST2INDEX1 TEST2 SYS_NC00003$
SQL> drop index test2index1;
Index dropped.
SQL> alter table TEST2 modify B VARCHAR2(24);
Table altered.
SQL> CREATE INDEX test2index1 ON test2(UPPER(B));
Index created.
Table created.
SQL> CREATE INDEX test2index1 ON test2(UPPER(B));
Index created.
SQL> alter table TEST2 modify B VARCHAR2(24);
alter table TEST2 modify B VARCHAR2(24)
*
ERROR at line 1:
ORA-30556: functional index is defined on the column to be modified
SQL> select * from user_ind_columns where table_name='TEST2';
INDEX_NAME TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------ ------------------
TEST2INDEX1 TEST2 SYS_NC00003$
SQL> drop index test2index1;
Index dropped.
SQL> alter table TEST2 modify B VARCHAR2(24);
Table altered.
SQL> CREATE INDEX test2index1 ON test2(UPPER(B));
Index created.
- ORA-30556错误
- 【ORA错误】ORA-12528
- ora-00341 ora-00312错误
- ora-01034 / ORA-27101 错误.
- ORA-01034&ORA-27101错误
- ORA-01034&ORA-27101错误
- ora-01034 ora-27101 错误
- ORA-01151;ORA-01537错误
- ORA-29913、ORA-30653错误
- ORA-07445 ORA-24324 ORA-01041错误
- ORA-03113错误分析
- ora-02085错误
- DataGuard - ORA-10567错误
- ORA-04098错误解决方法
- ORA-01658错误。
- ORA-04091错误解决
- ORA-01400错误
- ORA-02064 错误
- Windows xp中FTP站点的设置
- 性能优化篇
- Zebra-VTYSH源码分析和改造(二):深入代码
- 利用服务实现电话监听
- 曦力音视频转换专家-免费全能视频转换器(支持GPU加速)
- ORA-30556错误
- 写给新手 iOS 5.0.1完美越狱教程
- 实现多线程下载文件
- 正则表达式分析/提取XML/XHTML标签属性
- unbuntu下的软件安装方式
- 网络基础题
- Content Provider初步认识
- 回顾2011,展望2012
- c#二进制流的读和写(BinaryReader,BinaryWriter)