Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help:ORA-00054: resource busy and acquire with NOWAIT specified
Indeed TRUNCATE is a true DDL. But sometimes it's not obvious. For
instance, ALTER SYSTEM and ALTER SESSION do not commit a transaction.
This is because they don't "define or delete database objects" (cited
from documentation, definition of DDL, where warnings are not given
that not all ALTERs alter database objects).
But what about CREATE PROCEDURE? It does commit. We can say it inserts a row into data dictionary tables. How about ALTER PROCEDURE COMPILE? Test it. You'll see it also commits a transaction. How do we explain that?
Yong Huang
yong321_at_yahoo.com
"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message news:<CSDx8.48484$QC1.3441174_at_bgtnsc04-news.ops.worldnet.att.net>...
> To be more documentary for junior DBAs or programmers who might have
> occasion later on to look at or maintain the code, and don't know , or
> forgot, that because TRUNCATE is a DDL command and thus implicitly commits,
> an explicit commit is not necessary?
Received on Fri Apr 26 2002 - 12:46:49 CDT