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 ----- From: "Priyanka Deswal" <pdeswal_at_velos.ssind.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 12, 2000 11:20 PM 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).
Received on Fri Oct 13 2000 - 01:06:42 CDT