Re: ROLLBACK

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 - 06:38:07 CST