>>
>> Oracle auto-commits current in-progress transaction before
>> execution of any DDL statement and executes such statements in
>> separate transaction.
>
>That's cheating!
>
Dec (Oracle) Rdb cheats by locking a tables meta-data as soon as any user
accesses it, so that 'alter/drop table' will not run while that user is
attached. But is does support meta-data changes inside transactions
(assuming no-else who is currently connected has ever read that particular
meta-data). It is nice being able to rollback 'alter table' statements,
even under these strong restrictions.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: +61-03-5367 7422 | _________ \
Fax: +61-03-5367 7430 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/