Three Tier Oracle Security in London ~ Paul M. Wright

(nix, oracle, java, www, cloud ) intersect (safety, security, reliability, integrity)

Three Tier Oracle Security in London ~ Paul M. Wright RSS Feed
 

Action to SCN and SCN to time mapping

These two queries should be helpful especially in the absence of a timestamp column: SQL> select ora_rowscn, name from sys.user$;

ORA_ROWSCN NAME
———- ——————————
5072905 SYS
5072905 PUBLIC
5072905 CONNECT
5072905 RESOURCE
5072905 DBA
5072905 SYSTEM
5072905 SELECT_CATALOG_ROLE
5072905 EXECUTE_CATALOG_ROLE
5072905 DELETE_CATALOG_ROLE
5072905 EXP_FULL_DATABASE
5072905 IMP_FULL_DATABASE

SELECT To_Char(TIME_DP,’dd/mm/yyyy hh24:mi:ss’), SCN_BAS FROM SYS.SMON_SCN_TIME;
30/04/2006 10:07:00 9637921
30/04/2006 10:01:53 9637140
30/04/2006 09:56:46 9636359
30/04/2006 09:51:39 9635645

2 Responses to “Action to SCN and SCN to time mapping”

  1. 1
    Paweł Barut:

    Hello,
    You might find usefull my posts about ORA_ROWSCN.

    Regards,
    Paweł

  2. 2
    Paul Wright:

    Paweł,
    Thanks, I will take a look.
    Paul

Leave a Reply

You must be logged in to post a comment.