Ask the Expert

Solving the ORA-1650 error message

I got the following error message on my 7.3.4 Oracle: ORA-1650: unable to extend rollback segment R05 by 512 in tablespace RBS Failure to extend rollback segment 6 because of 1650 condition.

How do I check my current RBS size/extend condition and how do I increase its size? Thanks.

    Requires Free Membership to View

You can query DBA_ROLLBACK_SEGS view to see the rollback segments and their extent sizes. Querying DBA_SEGMENTS for the rollback segments will determine if the rollback segments are at their maximum extent:

SELECT segment_name, extents, max_extents FROM dba_segments WHERE segment_type='ROLLBACK';

If your rollback segments are at max extents, you can increase the max number of extents as follows:

ALTER ROLLBACK SEGMENT rollback_segment_name STORAGE (MAXEXTENTS xx);

It may also be likely that your rollback segment tablespace is full. Increase the size of the tablespace by adding another datafile to the tablespace:

ALTER TABLESPACE ts_name ADD DATAFILE '/directory/file_name' SIZE xxxM AUTOEXTEND ON NEXT xxxM MAXSIZE xxxM;

This was first published in January 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: