Re: Unable to insert records (ORA-1653)

From: Oracleguru <oracleguru_at_mailcity.com>
Date: Fri, 30 Oct 1998 19:24:43 GMT
Message-ID: <01be044b$76fe7b00$a504fa80@mndnet>

Hi

You need to commit every after certain number of records have been inserted, ohterwise you run into rollback segment and such problems. I would commit after every 10000 record inserts.\

Regards !!!

Oracleguru

Sanjay Hans <sanhans_at_mbox5.singnet.com.sg> wrote in article <01be0411$5a57a100$94cc15a5_at_oempre-install>...
> Would appreciate your help on the following problem which I am facing:
>
> I am trying to insert around 80000 records in a table having around
1521058
> records, after
> inserting 65914 records, the process hangs and alertDEV.log shows the
> following error message:-
>
> ORA-1653: unable to extend table/cluster CGO.REVENUES
> by 9360 in tablespace REL_TAB
>
> The table REVENUES was created with following parameters:-
> CREATE TABLE REVENUES ( )
> PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 230031360
> NEXT 76677120 MINEXTENTS 1 MAXEXTENTS 249
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "REL_TAB"
>
> The tablespace REL_TAB is having lot of space as shown by the result of
the
> following query:
>
> select sum(bytes),tablespace_name from dba_free_space group by
> tablespace_name;
>
> SUM(BYTES) TABLESPACE_NAME
> ---------- ------------------------------
> 312926208 RBS
> 2943057920 REL_IND
> 832356352 REL_TAB
> 187834368 SYSTEM
> 629129216 TEMP
>
> The other useful info you may need is :-
>
> The result of the following query:-
> select segment_name, pct_increase, sum(bytes),
initial_extent,next_extent,
> max_extents, count(*) from dba_extents a, dba_tables b where
> segment_name = b.table_name and segment_type = 'TABLE' and a.owner='CGO'
> and
> segment_name in ('REVENUES') group by
> segment_name, pct_increase, max_extents, initial_extent, next_extent
> order by segment_name, max_extents
>
> is
>
> SEGMENT_NAME
>

---

> -----
> PCT_INCREASE SUM(BYTES) INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS COUNT(*)
> ------------ ---------- -------------- ----------- ----------- ----------
> REVENUES
> 0 230031360 76668928 76677120 249 3
>
> Thanks in advance.
>
>
Received on Fri Oct 30 1998 - 13:24:43 CST