niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle
DDL and transactions
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
David Aldridge
*nix forums beginner


Joined: 03 Feb 2005
Posts: 46

PostPosted: Tue Feb 15, 2005 7:20 pm    Post subject: Re: DDL and transactions Reply with quote
Yup, it goes ...

i) commit
ii) apply DDL changes
iii) commit

.... so that a partial change to the data dictionary that fails can be
rolled back to the start of the DDL statement.
Back to top
vertigo
*nix forums addict


Joined: 23 Mar 2005
Posts: 71

PostPosted: Tue Feb 15, 2005 4:55 pm    Post subject: DDL and transactions Reply with quote
Hello

From documentation:

"DDL statements implicitly commit the preceding and start a new
transaction."

I assume they commit that new transaction which they started too ?

Thanx
Michal
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 2:45 am | All times are GMT
navigation Forum index » Databases » Oracle
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Transactions in PHP on SQL Server 2005 ~john PHP 4 Fri Jul 14, 2006 5:56 pm
No new posts Transactions requires much more UNDO space than expected.... mccmx@hotmail.com Server 14 Mon Jun 19, 2006 10:40 am
No new posts multithreading - managing transactions and sequence of pr... Jaco Smuts python 1 Mon May 22, 2006 7:22 am
No new posts a question about transactions and point-of-time yoram.ayalon@structuredwe Server 1 Tue May 16, 2006 3:25 pm
No new posts Oracle transactions and DDL statements. peter.koch.larsen@gmail.c Oracle 35 Mon May 08, 2006 2:42 pm

Bankruptcy | Debt Consolidation | Loans | Credit Cards | France Hotels
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1923s ][ Queries: 20 (0.0784s) ][ GZIP on - Debug on ]