| Author |
Beginning Oracle!
|
Younes Essouabni
Ranch Hand
Joined: Jan 13, 2002
Posts: 479
|
|
I searched the web for this information but didn't found anything accurate.
I'm trying to do a transaction with a rollback.
The rollback works fine for every dml statement, but not for ddl statement. For example, every table that I create, does still exist after a rollback. Does the rollback works only on DML statements?
Any help is welcome, thx in advance.
|
Younes
By constantly trying one ends up succeeding. Thus: the more one fails the more one has a chance to succeed.
|
 |
Shaha D
Greenhorn
Joined: Jul 16, 2002
Posts: 6
|
|
Yep, only DML statements can be rolled back. For DDL (Data Definition Language) statements Oracle issues an implicit COMMIT after the statement. The CREATE TABLE statement you issued to create table is a DDL so the table wont be erased.
You can find detailed explanation on transaction management in most of the database or Oracle books. Or you can refer to oracle manuals at the following site, once you sign up for OTN membership, which is free.
http://otn.oracle.com/docs/products/oracle9i/content.html
Go to "Concepts" link, under "Books for the New Application Developer" on the following site, which contains a chapter on Transactions (Chapter 16):
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/getting_started.htm
Cheers,
Shaha 
|
|
Younes Essouabni
Ranch Hand
Joined: Jan 13, 2002
Posts: 479
|
|
Thank you very much for your answers Shaha 
|
|
 |
|
|
subject: Beginning Oracle!
|
|
|
0
