摘要:
锁冲突原因:其他会话持有该表的锁,导致操作被阻塞 解决方案: -- 查看当前锁情况 SELECT * FROM sys_locks WHERE relation IN (SELECT oid FROM sys_class WHERE relname='表名'); -- 杀死阻塞进程 SELECT s 阅读全文
摘要:
BEGIN FOR t IN (SELECT table_name FROM user_tables) LOOP EXECUTE IMMEDIATE 'DROP TABLE "' || t.table_name || '" CASCADE CONSTRAINTS'; END LOOP; END; 阅读全文