If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

What is the storage parameter for the tablespace? Unlimited? Probably not.

ORA-01650: unable to extend rollback segment %s by %s in tablespace %s
Cause: Failed to allocate extent for the rollback segment in tablespace.
Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.

Error: ORA 1562 Text: failed to extend rollback segment (id = %s)
--------------------------------------------------------------------
Cause: Failure occurred when trying to extent rollback segment Action: This is normally followed by another error message that caused the failure. Shutdown, restart and then take appropriate action for the error the caused the failure. If starting up the system again doesn't solve the problem, it is possible that there is an active transaction in the rollback segment and the system can't roll it back for some reason(s). Check the trace file generated by the PMON process for more information.

currently, my rollback tablespace is over 15gb. i dont really understand this. since this rollback thing will shrink and grow accordingly to transactions. then when these transactions have committed, why space is not released and instead we have to keep adding data files?