Yes, that's default behavior. Any DDL statement automatically commits.
whether it worked or not.
See Thomas Kyte's book 'Expert one on one' for more info on that.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Pablo Gomez" <pgomeza_at_adinet.com.uy> wrote in message
news:962f505f.0205071456.6bf1cdc0_at_posting.google.com...
> Consider this transaction:
>
>
> SQL> commit;
> Commit complete.
>
> SQL> select * from emp;
> no rows selected
>
> SQL> insert into emp (empno, deptno) values (100, 10);
> 1 row created.
>
> SQL> select * from emp;
> EMPNO ENAME JOB MGR HIREDATE SAL
> COMM
> ---------- ---------- --------- ---------- --------- ----------
> ----------
> DEPTNO
> ----------
> 100
> 10
>
> SQL> alter tablespace a123 offline;
> alter tablespace a123 offline
> *
> ERROR at line 1:
> ORA-00959: tablespace 'A123' does not exist
>
> SQL> rollback;
> Rollback complete.
>
> SQL> select * from emp;
> EMPNO ENAME JOB MGR HIREDATE SAL
> COMM
> ---------- ---------- --------- ---------- --------- ----------
> ----------
> DEPTNO
> ----------
> 100
> 10
>
>
> As I can see the "alter tablespace ..." command makes a commit, what
> it's ok because is a ddl sentence, but I didn't know that when this
> sentence fails it makes a commit, like in this example where the
> tablespace not exits.
>
> Is this ok? Are there other situations similars where happens the
> same?
>
> Pablo Gomez Aguilera
> Twins Informatica
> Montevideo-Uruguay
Received on Tue May 07 2002 - 18:08:22 CDT
