oracle的几个不能

1.分区的不能之一

所建单表使用range分区时不能与复制其它表共用

使用其它表建表

create table test_table as select * from sorce_table where 1=2;

分区建表

create table test_table (rtime date)

partition by range (rtime)
(
partition p1 values less than (to_date('2015-03-15','YYYY-MM-DD'))
);
以下语句

create table test_table

as select * from sorce_table where 1=2
partition by range (rtime)
(
partition p1 values less than (to_date('2015-01-01','YYYY-MM-DD'))
);

故障提示:

[Error] Execution (5: 1): ORA-00933: SQL 命令未正确结束

 2.sys_refcursor不能

sys_refcursor不能放到生成的sql语句中

如

f_cursor out sys_refcursor

..

execstr:='open f_cursor for select * from target table';

只能采用

open f_cursor for execstr;

--待续