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: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Fri, 08 Sep 2000 09:10:45 +0200
Message-ID: <39B890F5.D242EBBA@cern.ch>

Hello,

Just write commit...:)

SQL> commit;

Commit complete.

Erika

mike wrote:
>
> hi spencer:
> then what should i do?
>
> thank u
>
> "spencer" <spencerp_at_swbell.net> wrote in message
> news:tn%t5.762$3S.148958_at_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 - 02:10:45 CDT

Original text of this message

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