摘要:
/*迁移表的表空间 */ SELECT 'alter table ' || TABLE_NAME || ' move tablespace KAVINS;' FROM ALL_TABLES WHERE OWNER = 'KAVINS'; /*迁移索引表空间*/ SELECT 'alter index 阅读全文
摘要:
ORA-00904: : invalid identifier grant execute on DBMS_JAVA to user; 阅读全文
摘要:
DELETE FROM T_USER; INSERT INTO T_USER SELECT * FROM T_USER AS OF TIMESTAMP TO_TIMESTAMP('2021-01-19 09:06:00', 'yyyy-mm-dd HH24:mi:ss')--回滚到某个时间 COMM 阅读全文
摘要:
DELETE FROM TABLE_NAME A WHERE (A.FIELD1, A.FIELD2) IN (SELECT FIELD1, FIELD2 FROM TABLE_NAME GROUP BY FIELD1, FIELD2 HAVING COUNT(*) > 1) AND ROWID N 阅读全文
摘要:
--以下几个为相关表 SELECT * FROM V$LOCK; SELECT * FROM V$SQLAREA; SELECT * FROM V$SESSION; SELECT * FROM V$PROCESS; SELECT * FROM V$LOCKED_OBJECT; SELECT * FR 阅读全文