Skip to Content
0
Former Member
Aug 05, 2008 at 03:56 PM

Error when deleting a customer table

57 Views

Hi guys, im deleting a Z table with a loop, and the following error is displayed after 10 minutes.

the log reads as follow.

-

-


1. ORACLE storage space request failed.

(ORACLE error 1547)

-

-


To execute this operation, the ORACLE instance needs more

storage space for a segment. This storage is

managed by ORACLE in logical units known as extents.

The size of an extent depends on the segment definition and

the current storage situation.

One segment (possibly more) is stored in one tablespace.

The storage space available for a tablespace must be explicitly

preallocated by the database adminstrator. If, in course of time, the

volume of data in this tablespace increases considerably, the storage

space may be filled up (in real terms or through fragmentation).

-

-


2. Maximum number of extents reached for rollback segment.

(ORACLE error 1556)

-

-


To execute this operation, the ORACLE instance needs more

storage space for a segment. This storage is

managed by ORACLE in logical units known as extents.

The size of an extent depends on the segment definition and

the current storage situation.

For each segment, the ORACLE instance can manage only a certain number

of extents. The maximum number for this

segment has been reached.

HERE THE CODE:

DO 48 TIMES. " HASTA 4 años.

DELETE FROM (p_ztable)

WHERE perio = periodo.

IF mes = '01' OR mes = '1'.

mes = 12.

anio = anio - 1.

ELSE.

mes = mes - 1.

ENDIF.

CONCATENATE ANIO '0' MES INTO PERIODO.

ENDDO.

any ideas?