admin 管理员组文章数量: 1086019
I have flashback enabled (as sysdba) for a table on my oracle 19 database:
CREATE FLASHBACK ARCHIVE flashback_at0672 TABLESPACE users
QUOTA 10G RETENTION 1 YEAR;
ALTER TABLE at0672.assays FLASHBACK ARCHIVE flashback_at0672;
When I try to alter the table the session hangs - and the table is blocked.
ALTER TABLE at0672.assays add dummy varchar2(20);
I have experienced this on different db users - and on different db server instances. No other users or sessions are logged in at that time.
The lock is showing in gv$locked_object
, but I could not find references, what causes the lock. I also have not been able to release the lock anyhow - except by restarting the whole database.
One common thing: All my databases are non-container databases.
本文标签: oracle databaseDDL operation hangs on table with Flashback enabledStack Overflow
版权声明:本文标题:oracle database - DDL operation hangs on table with Flashback enabled - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.roclinux.cn/p/1744081091a2530258.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论