아주 상식적으로 생각해서 나는 rollback이라고 생각하고 있었다.
하지만 팀장님 말을 듣고 실제 테스트해보니.. commit이었다.
[oracle@centos5 ~]$ sqlplus scott/tiger
Connected to:
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
GLOBAL_NAME
----------------------------------------------------------------------------------------------------
scott@TESTDB
scott@TESTDB> select * from t;
NO
----------
1
scott@TESTDB> update t set no=2;
1 row updated.
scott@TESTDB> exit
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
[oracle@centos5 ~]$ sqlplus scott/tiger
Connected to:
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
GLOBAL_NAME
----------------------------------------------------------------------------------------------------
scott@TESTDB
scott@TESTDB> select * from t;
NO
----------
2
Oh my god!
'Knowledge > Oracle' 카테고리의 다른 글
| Oracle Standard Edition 으로 RAC 구성시 제약사항 (0) | 2013.05.21 |
|---|---|
| Oracle process and Files (0) | 2013.03.18 |
| ROW_CHAIN 해결 비교 (0) | 2013.02.18 |
| Control file dump 뜨기 (0) | 2013.01.04 |
| Opatch 사용법 (0) | 2012.12.27 |
