This DB has no "recorded" history when 1133049 occurred.
SQL> select current_scn from v$database; CURRENT_SCN ----------- 2509975 SQL> select distinct ora_rowscn from hr.emp; ORA_ROWSCN ---------- 1133049 SQL> select scn_to_timestamp(ora_rowscn) from hr.emp; select scn_to_timestamp(ora_rowscn) from hr.emp * ERROR at line 1: ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
992700 wrote:not possible
My name is giridhar. i have a doubt,please clarify me.
can we write a single trigger of all tables in the database.
I want to write a java program that captures changes(update,insert,delete) made to every table in the database.
can we do that,is that possible through java program.
please help me.