 iSQL*plus of Oracle 10g [message #144022] |
Mon, 24 October 2005 13:07  |
syan
Messages: 1
Registered: October 2005
|
Junior Member |
|
|
I just tried using iSQL*plus of Oracle 10g to execute SQL commands, e.g.,insert into numbers values(9999,1243,6666); where numbers is the table name. After execution, the screen showed "1 row created.". However, i back to the Enterprise Manager and view data of this table called numbers, the new record doesn't show there at all. So, I logged out EM and logged into it one hour later, the new record (9999,1243,6666)appears in the table!!! Why so late!
Could you please help me with this? Thanks.
Sam
|
|
|
|
|
|
| Re: iSQL*plus of Oracle 10g [message #144124 is a reply to message #144105] |
Tue, 25 October 2005 03:23  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
This is to do with read consistency. If you perform DML on a table, but do not commit that transaction, then other sessions will not be able to see it. You EM session is a different session. When you logged outr of your main session it performed a commit, thereby making that new row available to 'all and sundry' hence the end result that you saw.
Read up on read consistency in the Oracle docs.
HTH
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
