Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> alter tablespace fails but makes commit
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 - 17:56:13 CDT