Database Backup and Recovery (MOSC)

MOSC Banner

cannot use system rollback segment for non-system tablespace 'TOOLS'

edited Dec 11, 2009 8:47AM in Database Backup and Recovery (MOSC) 7 commentsAnswered
 Hi !!
I am using Oracle 11g on Redhat Linux-5.
I have duplicated my production database using RMAN on the same machine.
After successful completion, when I try to create a table it gives me error :

 cannot use system rollback segment for non-system tablespace 'TOOLS'


I have ran some checks as following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
select segment_name, tablespace_name, initial_extent,status from dba_rollback_segs;

SEGMENT_NAME     TABLESPACE_NAME           INITIAL_EXTENT STATUS
------------------------------ -------------------------------------------  ----------------
SYSTEM                    SYSTEM                                57344 ONLINE
R01                            RBS                                   1048576 OFFLINE
R02                            RBS                                   1048576 OFFLINE
R03                            RBS                                   1048576 OFFLINE
R04                            RBS                                   1048576 OFFLINE

show parameter undo                                            

NAME                             TYPE     VALUE
------------------------------------ ----------- ------------------------------
undo_management            string      AUTO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center