Re: The ROLLBACK don't cancel instructions

"Ben-oui" <aslamette_at_free.fr> a écrit dans le message news: sLGl7.3680$_M3.4388988_at_nnrp5.proxad.net...
> I have a script :
>
> set autocommit off;
> drop table pcomessaisuite;
> commit;
> set transaction read write;
> create table pcomessaisuite (toto varchar(5));
> alter table pcomessaisuite add toto3 varchar(6);
> rollback;
> describe pcomessaisuite;
>
> Normally the table ESSAISUITE wouldn't create and an error would be create
> on last line. But Oracle create the table in spite of the ROLLBACK.
>
> Can you help me ?
>
> Thank.
>

All DDL statements (drop, create, alter...) are auto-committed. That is there a commit before and after each of these statements so you can't rollback them.

--
Have a nice day
Michel