Re: DBMS_ERRLOG.CREATE_ERROR_LOG

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 5 Nov 2008 17:21:01 +0100
Message-ID: <4911c7ee$0$1893$426a74cc@news.free.fr>

"KevinS" <SearleK_at_googlemail.com> a écrit dans le message de news: 2b2edbd3-125f-4778-8010-fda54e0b397a_at_f37g2000pri.googlegroups.com...
| Hi all,
|
| If a logging table is created using the above function call, how are
| changes to structure of the underlying tabel (the one on with the
| logging table is based handled.

There are not.

|
| i.e. if a column is added, dropped or modified does this change
| cascade through to the error logging table?

No.

|
| If it doesn't and an error occurs during DML applied to the base table
| what are the knock on effect in error logging machanism?

It fails.

|
| Thanks
Received on Wed Nov 05 2008 - 10:21:01 CST

Original text of this message