OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » constraint

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

constraint [message #528843]

Thu, 27 October 2011 07:50

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

Quote:

A constraint violation will
force an automatic rollback of the entire
statement that hit the problem, not just
the single action within the statement,
and not the entire transaction.

i don't quite get it. The part on 'and not the entire transaction'.

The first part have already mention it will rollback the ENTIRE statement.

Report message to a moderator

Re: constraint [message #528849 is a reply to message #528843]

Thu, 27 October 2011 08:01

John Watson
Messages: 8996
Registered: January 2010
Location: Global Village

Senior Member

I recognize this as a quote from my book. I asked before, do you have a proper copy of it, or only a copy of it on CD?

Report message to a moderator

Re: constraint [message #528854 is a reply to message #528843]

Thu, 27 October 2011 08:11

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And explain what you don't understand.

Regards
Michel

Report message to a moderator

Re: constraint [message #528859 is a reply to message #528843]

Thu, 27 October 2011 08:25

flyboy
Messages: 1903
Registered: November 2006

Senior Member

hanner wrote on Thu, 27 October 2011 14:50

i don't quite get it. The part on 'and not the entire transaction'.

The first part have already mention it will rollback the ENTIRE statement.

Transaction != statement.

Maybe you should firstly get familiar with basic database terms. They are also described in Concepts book, available with other Oracle documentation e.g. online on http://tahiti.oracle.com/

For 11gR2, transactions are described here: http://download.oracle.com/docs/cd/E11882_01/server.112/e25789/transact.htm#i6564

Report message to a moderator

Previous Topic:	patch versioning documentation
Next Topic:	table size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 29 04:03:18 CST 2026