Re: ROLLBACK

or commit more often...

randy

Sybrand Bakker wrote:

> The only thing you can do to 'reinitialize' a rollback segment is either
> COMMIT or ROLLBACK.
> Apparently your transaction (that's what happened after the last commit or
> rollback) is so big, the rollback segment is full, must extend and can't
> because there is no space in the tablespace.
> In normal circumstances you would either resize a datafile or add one.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <a.metzger_at_nmg.fr> wrote in message news:38C4EC3B.CB9216C8_at_nmg.fr...
> > Hi,
> >
> > I want to insert data in a database. But after few minutes, I receive
> > this :
> > ORA-01562, and ORA-01650.
> > In the documentation it is said to "Use ALTER TABLESPACE ADD DATAFILE
> > statement to add one or more files to the tablespace indicated".
> > But I don't want to add files to my tablespace.
> > Can I reinitialyze my roolback or something else ?
> >
> > - A. Metzger -
> >
Received on Tue Mar 07 2000 - 13:03:47 CST