admin 管理员组

文章数量: 1086458

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， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。