Re: Inserting records through interface.

Thanks Nikunj

I dont think archive log has any problem. Because the other user clients are successfully connecting to the database. And even I dont think that there is any bad record because I have entered the same data in my test database. Of course there should be no problem with the rollback segment because I am commiting after each record.

Priyanka

• Original Message ----- From: Nikunj Gupta <good_dba_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, October 13, 2000 12:30 Subject: Re: Inserting records through interface.

> Hi,
>
> Since you are committing after every insert.. you can check the extents
> table has reached.. may be your rollback segment has problems.. BUT with
> COMMIT that should also be not there...
>
> May be you have problem with ARCHIVE LOG destination being full..
>
> There could be many reasons.. You could have bad data after that record..
if
> it repeatedly happens on that particular record...
>
> N reasons.. for this..
>
> Check some of these...
>
> Good Luck..
>
> Nikunj
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, October 12, 2000 11:20 PM
>
>
> > 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: Nikunj Gupta
> INET: good_dba_at_hotmail.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
Received on Fri Oct 13 2000 - 01:52:32 CDT