介绍两种方式:
一、sys用户下:
select current_scn from v$database;
select dbms_flashback.get_system_change_number as scn from dual;
二、普通用户下:
—普通用户需要有dbms_flashback的权限
---授权给lgr用户
SYS@ENMOEDU> grant execute on dbms_flashback to lgr;
Grant succeeded.
---lgr用户下查询
LGR@ENMOEDU> select dbms_flashback.get_system_change_number as scn from dual;
SCN
----------
1061428