Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit

From: <reidlai_at_hk.super.net>
Date: Tue, 12 Jan 1999 09:18:35 GMT
Message-ID: <77f419$ea8$1@nnrp1.dejanews.com>

I am sorry to mistype the word. Thank you.

In article <3699242a.43681460_at_news.siol.net>, jmodic_at_src.si (Jurij Modic) wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 12 1999 - 03:18:35 CST