Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit

Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sun, 10 Jan 1999 14:52:37 +0800
Message-ID: <36984E35.ECF31377@hk.super.net>


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

snapondba_at_hotmail.com wrote:

> Does the DBMS_DDL.ANALYZE_OBJECT procedure cause an implicit commit within a
> PL/SQL block? A procedure we developed populates several staging tables and
> updates some production data. I think our performance will increase if we can
> analyze the staging tables, but want the option to rollback all activity upon
> an exception. If the analyze performs an implicit commit we lose the ability
> to rollback everything.
>
> Any thoughts?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Best Regards,

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



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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US