Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cache problem?

Re: cache problem?

From: spencer <spencerp_at_swbell.net>
Date: Fri, 8 Sep 2000 01:09:06 -0500
Message-ID: <tn%t5.762$3S.148958@nnrp1.sbc.net>

"mike" <skyxx_at_263.net> wrote in message news:8p9vds$30p9$1_at_news.cz.js.cn...
> hi all:
> i insert 10000 records into table "test" on a workstation,but when i use
> another workstation to select the table "test",the sql plus returned 0
> record,why?and i meet other problem,very like this ,i deleted some records
> from a table but i still can select these records on another workstation.
> thank u
>

I'm guessing that you did not commit your work. Other sessions can not and will not see the INSERTed rows until you issue a COMMIT statement. Received on Fri Sep 08 2000 - 01:09:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US