ORA-02287: sequence number not allowed here解决
来源:互联网 发布:java 弱引用 使用场景 编辑:程序博客网 时间:2024/06/06 17:14
脚本中插入数据:
ORA-02287: sequence number not allowed here问题的解决
思路:通过临时表“转移”数据。
解决方法:
1、新建临时表,将数据插入临时表中
create table table1_tmp();
insert into table1_tmp select * from *;
2、新建序列,将临时表数据插入正式表中
--drop sequence seq1;
create sequence seq1
start with 1
increment by 1
nomaxvalue
cache 20;
insert into table1 select seq1.nextval, tmp.* from table1_tmp tmp;
3、drop临时表
drop table table1_tmp;
ORA-02287: sequence number not allowed here问题的解决
思路:通过临时表“转移”数据。
解决方法:
1、新建临时表,将数据插入临时表中
create table table1_tmp();
insert into table1_tmp select * from *;
2、新建序列,将临时表数据插入正式表中
--drop sequence seq1;
create sequence seq1
start with 1
increment by 1
nomaxvalue
cache 20;
insert into table1 select seq1.nextval, tmp.* from table1_tmp tmp;
3、drop临时表
drop table table1_tmp;
0 0
- ORA-02287: sequence number not allowed here解决
- ORA-02287: sequence number not allowed here
- insert into...select from...ORA-02287: sequence number not allowed here问题
- ORA-02287:此处不允许序号(sequence number not allowed here) 的避免以及强制实现
- ORA-02287:此处不允许序号(sequence number not allowed here) 的避免以及强制实现
- Oracle ORA-00984: column not allowed here
- ORA-01733: virtual column not allowed here
- column not allowed here
- magento:DirectoryIndex not allowed here
- 用merge into 的时候提示 ORA-01733: virtual column not allowed here
- element filtername is not allowed here
- listener Element listener-calss not allowed here
- Element multipart-config is not allowed here
- element filter-name is not allowed here
- element listener-class is not allowed here
- PAIP.HIBERNATE ORA-02289 sequence does not exist的解决
- ORA-24323: value not allowed ORA-01089
- Delphi - 关于错误E2002 File Type is not allowed here
- wosa测试培训讲义
- 噩梦射手 心得 移动旋转面向 摄像机跟随
- 重学java23种设计模式(1)工厂方法模式
- 共享cookies数据
- JSP中用js控制添加行,删除行
- ORA-02287: sequence number not allowed here解决
- 用rman创建辅助数据库duplicate
- css input[type=file] 样式美化,input上传按钮美化
- Lambda
- 第四章、代码结构
- VS2013 调用的目标发生了异常
- JAVA中replace和replaceAll的区别
- opencv形状分析
- Online Judge System For SzNOI 题库 语法百题 C++ d006