【Oracle问题集5】ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table
来源:互联网 发布:网络画手是什么意思 编辑:程序博客网 时间:2024/05/17 23:47
说明:【oracle问题集】是博主平时操作数据库遇到的问题以及解决方案。
执行语句:表示操作数据库过程出错现象:表示操作数据库过程出现错误现象出错原因:表示出现错误的原因解决方法:表示解决错误的方法相关知识:表示与这个主题相关的知识==============================================================执行语句:删除表空间报错误,drop tablespace 表空间名出错现象:ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table "PROC"."SYS_FBA_TCRV_76187"错误原因:用户想要删除那些拥有授权的闪回特征的表解决方法:收回相应表被授权的闪回权限1、找出发生错误的表
"PROC"."SYS_FBA_TCRV_76187" 其中 76187是id号在闪回存档中的授权号
SQL> select object_id,owner,object_name from dba_objects where object_id='76187'
OBJECT_ID OWNEROBJECT_NAME
---------- -------------------- ------------------------------
76187 PROC TEST017
2、找出授权的闪回存档中的所有表(需要owner登录并允许,例如proc)
SQL> select table_name from user_flashback_archive_tables;
TABLE_NAME
------------------------------
TEST017
3、收回表中的闪回归档功能
alter table <owner>.<tablename> no flashback archivew;
4、执行删除表空间命令
drop tablespace tableName including contents and datafiles;
相关知识:flashback archive
- 【Oracle问题集5】ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table
- 遇到ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations错误
- ORA-14452: attempt to create, alter or drop an index on temporary table already in use
- ORA-14452: attempt to create, alter or drop an index on temporary table already in use
- ODI主键报错--create unique index on flow table
- create unique index与alter .. add constraint .. unique的差异
- Oracle创建唯一索引遇到的问题(ORA-01452: 无法 CREATE UNIQUE INDEX; 找到重复的关键字)
- OpenSessionInViewFilter与Write operations are not allowed in read-only mode 独门问题解决之道
- SSH整合问题:Write operations are not allowed in read-only mode
- Oracle to create table、sequences、index and view --- cxl
- Write operations are not allowed in read-only mode
- Write operations are not allowed in read-only mode
- Write operations are not allowed in read-only mode
- operations are not allowed in read-only mode
- operations are not allowed in read-only mode
- Write operations are not allowed in read-only mode
- org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed
- Write operations are not allowed in read-only
- css ie6、ie7、ie8中overflow:hidden无效解决办法
- T检验和F检验
- vs2008快捷键大全
- linux 管道介绍
- Win7语音聊天对方听不到自己的声音怎么办
- 【Oracle问题集5】ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table
- wifi模块:marvell-8686
- Redhat搭建SVN服务器
- Android学习笔记之详细讲解画圆角图片
- win2003服务器安全设置完全教程
- Silverlight中调用麦克风模拟录音机设备,存储为WAV音频
- 开开小玩笑 让Windows 7系统屏幕来个大翻转
- android使用Jsoup进行html数据解析简单实例浅析
- C++解析Json数据