摘要:
删除表 SQL> drop table c##sapr3.test; Table dropped. SQL> select count(*) from c##sapr3.test; select count(*) from c##sapr3.test * ERROR at line 1: ORA-0 阅读全文
摘要:
问题: ORA-38707: Media recovery is not enabled. SQL> alter database flashback on ; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn 阅读全文
摘要:
问题:删除表数据不会导致高水位线下降,不会使用查询效率, 模拟: 创建表,分析表 SQL> create table TEST as select * from TESTT1; Table created. SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('c##sa 阅读全文