Re: ROLLBACK

a.metzger_at_nmg.fr wrote:
>
> 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 -

You do not have enough room in the datafile used by your rollback segments. The solution to this problem will be determined by how you have your rollback segments set up. Here are some potential solutions:

1. If you have online rollback segments in your SYSTEM tablespace other than the SYSTEM rollback segment then you need to move the rollback segments to another tablespace - preferably one that only has other rollback segments.
2. If your rollback segments are in tablespaces other than SYSTEM and those tablespaces are shared with data then you need to increase the size of that tablespace.
3. If the problem is just that the size of the transaction is large, then decrease the size of the transaction by performing more frequent commits.
4. If all of your rollback segments are in a tablespace that is only used by rollback segments then turn AUTOEXTEND on while you are doing this data load. Once the data load is complete you can then resize the tablespace back to a smaller size. Depending on the nature of your load you may still have to play around with rollback segments to get one that is big enough to handle the task. Many DBAs create an extra-large rollback segment just for huge transactions and only put that rollback segment on-line when needed and then take it off-line for normal operations. You would then take action to ensure that the large rollback segment is used by your transaction.