1.不能为用户自定义的类型的属性建立索引
文档这样说:You cannot create an index on columns or attributes whose type is user-defined
column
Specify the name of a column in the table. A bitmap index can have a maximum of 30 columns. Other indexes can have as many as 32 columns. Restriction: You cannot create an index on columns or attributes whose type is user-defined, LONG, LONG RAW, LOB, or REF, except that Oracle supports an index on REF type columns or attributes that have been defined with a SCOPE clause.2.select table_name from user_tables where table_name='YOURTABLE';
文档这样说:You cannot create an index on columns or attributes whose type is user-defined
column
Specify the name of a column in the table. A bitmap index can have a maximum of 30 columns. Other indexes can have as many as 32 columns. Restriction: You cannot create an index on columns or attributes whose type is user-defined, LONG, LONG RAW, LOB, or REF, except that Oracle supports an index on REF type columns or attributes that have been defined with a SCOPE clause.2.select table_name from user_tables where table_name='YOURTABLE';
解决方案 »
- 数据库建表问题
- 有关oracle的问题!!!
- oracle 中replace函数使用
- 很纠结的查询效果?大侠进来帮忙看看
- 过程便已有错误,但我没发现哪有问题
- !!!急!!!关于ORACLE备份和导出数据的问题
- 怎么创建一个用户拥有 查询所有schema 表 视图 索引 函数 存储过程 触发器 包 序列的权限
- 简单问题--创建视图sql语句
- PL/SQL连接数据库菜问题(很容易拿分的,谁先回答上来,谁先拿分)
- 怎么把一个大的字符串存到数据库的一个字段里
- 现有数据库中的一个字段,比如:一个name 对应 tel: 010-66666666,我现在想将这个列分为两个列,010 和 66666666,name 有重复,我应该怎
- ***求助:删除所有的数据,只保留空行?谢谢!*****
关于第二个问题
应该有判断语句阿,判断目前的方案中是否有表名与将要建立的新表表名重合,如果有,才drop掉的阿,土土的问,脚本如何写捏?