Q

Solving the ORA-1650 error message

Oracle expert Brian Peasland explains how to solve 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.

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 last published in January 2008

Dig Deeper on Oracle database administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close