Tuesday, June 23, 2020

SCN



SCN

select current_scn from v$database;

select timestamp_to_scn(to_timestamp('24/06/2020 14:44:45','DD/MM/YYYY HH24:MI:SS')) as scn from dual;

select scn_to_timestamp(7705798324) as timestamp from dual;

No comments:

Post a Comment

student guide Dataguard: GLOBAL_DBNAME = <dbuniquename>_DGMGRL.example.com  Example: listener.ora on Primary Hosts Static listener ent...