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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Inserting records through interface.

Re: Inserting records through interface.

From: Priyanka Deswal <pdeswal_at_velos.ssind.com>
Date: Fri, 13 Oct 2000 13:07:30 +0530
Message-Id: <10648.119143@fatcity.com>


No there are no error messages. Its just that the system hangs.( My redo buffer size is 32k)

> Is there any ORACLE error messages such as ORA-0600 ?
>
> > -----Original Message-----
> > From: pdeswal_at_velos.ssind.com [SMTP:pdeswal_at_velos.ssind.com]
> > Sent: Friday, 13 October 2000 5:20 pm
> > To: Multiple recipients of list ORACLE-L
> > Subject: Inserting records through interface.
> >
> > Hi All
> >
> > I have a problem with inserting records into a table. I am inserting
into
> > a
> > table through an interface. After each insert its committing.But after
> > 32000
> > records the interface hangs.What could be the possible reason something
> > related to extents of table or otherwise.
> >
> >
> > Kindest Regards
> > Priyanka
> > pdeswal_at_velos.ssind.com
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Priyanka Deswal
> > INET: pdeswal_at_velos.ssind.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Casipit, Joel
> INET: Joel.Casipit_at_team.telstra.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 13 2000 - 02:37:30 CDT

Original text of this message

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