查询数据库当前的SCN的方法:
1、通过 dbms_flashback.get_system_change_number来获取;
2、通过 v$database视图中的CURRENT_SCN 来获取;
select dbms_flashback.get_system_change_number from dual;
WHERE STATUS = 'CURRENT';
select current_scn from v$database;
查询数据库当前的SCN的方法:
1、通过 dbms_flashback.get_system_change_number来获取;
2、通过 v$database视图中的CURRENT_SCN 来获取;
select dbms_flashback.get_system_change_number from dual;
WHERE STATUS = 'CURRENT';
select current_scn from v$database;