ORA-12986
来源:互联网 发布:超级基因优化液百科 编辑:程序博客网 时间:2024/06/08 14:37
今天在删除一个大表的列,意外被DBA重启DB后,再执行查询时,就报了ORA-12986这个错误,先来一起了解下这个错误:
Cause: An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).
Action: Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.
可以看到导致这个错误的原因是因为你正在删除列,但是删除到一半时,进程被意外终止了,导致表处在部分删除状态,所以报了咋么个错误,你要做的就是继续删除,看下下面的例子:1.将列置为unused
ALTER TABLE test1 SET UNUSED COLUMN Tablespace_name;
2.删除unused列
ALTER TABLE test1 DROP UNUSED COLUMN CHECKPOINT 5;
在未执行完毕前,用 shutdown abort强制关闭数据库(如果用shutdown immediate就看不到效果,它会等到执行完毕才会关闭数据库)
3.重新启动数据库,查看test1表,报错
4.继续删除未删完的列
ALTER TABLE test1 DROP COLUMNS continue
5.执行完毕后再次查询test1表,就OK了
- ORA-12986
- ORA
- ora
- ORA-01034 ORA-27101
- ORA-10567,ORA-00313
- ora-01128,ora-00275
- ORA-03113,ORA-07445
- ORA-32017 ORA-16179
- ORA-12012,ORA-12005
- ora-01034 ,ora-27101
- ora-603 ora-27504
- ora-01113 ora-01110
- ORA-24324 & ORA-01041
- tnsnames.ora & listener.ora
- ORA-09817&ORA-01031
- ORA-00604 & ORA-25153
- ORA-38029 & ORA-20005
- ORA-28002,ORA-01502
- 从JVM的常见异常来看Tomcat中内存的设置
- Oracle学习笔记安装篇之在Redhat Enterprise Linux 6.3 x86_64下安装Oracle11g R2
- listview实现的tree树结构
- R语言对矩阵按某一列排序
- session的持久化原理
- ORA-12986
- ORACLE:object_id vs data_object_id
- JNI入门
- 矩阵分解
- 社交网络分析(Social Network Analysis)
- JSP的一些小知识
- HDU 1964 Pipes 解题报告(插头DP)
- ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
- WPF: drawing a video using MediaPlayer, VideoDrawing and DrawingBrush