Three Tier Oracle Security in London ~ Paul M. Wright

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

March 22nd, 2007 | Category: Uncategorized | Subscribe to comments | You can skip to the end and leave a response. Pinging is currently not allowed