Q
Problem solve Get help with specific problems with your technologies, process and projects.

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;

Dig Deeper on Oracle database administration

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close