Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Dirty Read Question
nothing can be seen by other users, or even the same user in another session, until a commit occurs. There are some things that do forced a commit (quit, exit, create table, grant, connect, etc ........). Also in sqlplus autocommit could be set. from your example you did a grant and a connect which would have commited your work in the session where the insert took place
Regards,
Richard Fuoco
On Mon, 07 Apr 1997 15:52:47 -0700, Vish magapu <magapuv_at_ix.netcom.com> wrote:
>According to Oracle manuals (for Ver 7.1) Oracle Never does a "dirty
>read". That means (as I understand) if somebody wites the data but has
>not committed, others users will not be able to see it. But suppose I
>executed the following sequence of statements:
>login as scott/tiger
>create table test (col1 varchar2(1));
>-- Grant select to someuser on test
>insert into test vlaues('X');
>-- But I do not commit;
>login as someuser;
>select * from test;
>-- I get one row which is 'X'
>If Oracle does not do dirty reads how this is possible. Am I
>mis-understanding the concept.
>Please help.
>
>Thanks,
>Vish
>
>--------------------------------------------------------------
>Name: Vish Magapu
>E-mail: Vish Magapu <magapu_at_monet.fujitsu.com>
>Date: 04/07/97
>Time: 15:44:24
>--------------------------------------------------------------
>
Received on Mon Apr 07 1997 - 00:00:00 CDT