Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 10 Jan 1999 22:40:14 GMT
Message-ID: <3699242a.43681460@news.siol.net>

On Sun, 10 Jan 1999 14:52:37 +0800, Reid Lai <reidlai_at_hk.super.net> wrote:

>Of course. Whenever you issue DML statement, Oracle will perform commit
>immediately after execution. Hope this can help you.

I'm sure you realy ment "Whenever you issue *DDL* statement....". Btw, whenever you perform DDL statement, Oracle performs *two* implicit commits: one before the DDL execution and one after it.

>Best Regards,
>
>Reid Lai <reidlai_at_hk.super.net>
>Oracle 7.3 Certified Database Administrator (OCP)

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Jan 10 1999 - 16:40:14 CST