ORA-01650 1

[jestrada101]

ORA-01650: unable to extend rollback segment R03 by 64 in tablespace RBS03

Would adding more space resolve this?

 

[LKBrwnDBA]

Yes, but what if next time you execute the SQL, it uses a different rollback segment (like R04)?

If you create a BIG rollback segment, you can force it's use by one of the following:

SET TRANSACTION USE ROLLBACK SEGMENT RBIG;
-- Or within a PL/SQL Block:
...
DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT(RBIG);
...

Note: The "SET TRANSACTION" must follow a "COMMIT;" and precede the Statement to use the specified rollback segment.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[jestrada101]

I'm getting the failure when doing an import. HOw can I tell it to use my big RBS?

Thansk!

 

[sem]

You may switch off all the rest

Regards, Dima

http://seminihin.narod.ru

 

[LKBrwnDBA]

Or you can use the COMMIT=Y import option (parameter).



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[jestrada101]

Thanks Commit=Y worked!