Siiiip , pakai feature FLASHBACK QUERY saja.
Contoh:
Sbg user scott saya membuat sebuah trigger sederhana.
SQL> conn scott/tiger
SQL> CREATE OR REPLACE TRIGGER trg1
2 AFTER INSERT ON emp
3 BEGIN
4 NULL; -- awal
5 NULL; -- awal
6 NULL; -- awal
7 END;
8 /
Trigger created.
:::------------------------------------:::
:::CATAT WAKTU SEBELUM ADA REPLACEMENT :::
:::------------------------------------:::
SQL>
SQL> select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'DD
-------------------
17-02-2006 18:17:08
:::----------------------------:::
:::REPLACE OLD TRIGGER CONTENT :::
:::----------------------------:::
SQL>
SQL> CREATE OR REPLACE TRIGGER trg1
2 AFTER INSERT ON emp
3 BEGIN
4 NULL; -- perubahan
5 NULL; -- perubahan
6 NULL; -- perubahan
7 END;
8 /
Trigger created.
SQL> select TRIGGER_BODY from user_triggers where
TRIGGER_NAME='TRG1';
TRIGGER_BODY
------------------------------------------------
BEGIN
NULL; -- perubahan
NULL; -- perubahan
NULL; -- perubahan
END;
:::------------------------:::
:::LOGIN SEBAGAI SYSDBA/DBA:::
:::------------------------:::
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL> select TRIGGER_BODY from dba_triggers
2 as of timestamp TO_TIMESTAMP('17-02-2006 18:17:08','dd-mm-yyyy
hh24:mi:ss')
3 where TRIGGER_NAME='TRG1' and OWNER='SCOTT';
TRIGGER_BODY
---------------------------------------------------------
BEGIN
NULL; -- awal
NULL; -- awal
NULL; -- awal
END;
Bowo
--- In [email protected], Herman <[EMAIL PROTECTED]> wrote:
>
> Yulius Wibowo wrote:
>
> >Punya backup database-nya?
> >Logical (pakai exp) or Physical ?
> >
> >
> Tidak.. :( soalnya ini hanya database untuk oprek2..
>
> >Alternatif lain pakai LogMiner ... cuma saya belum tahu apakah
bisa
> >juga utk explore perubahan akibat DDL / di data dictionary khusus
> >utk trigger ... (aku coba dulu ya ...)
> >
> >
> >
> Thanks before !
>
> --
>
> Herman
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
