|
-
Hi ,
User got ORA-01555 error , And My database is runnong with rollback segments ?
User got following error ? ORA-01555 'UNABLE TO EXTEND ROLLBACK SEGMENT RBS_O4'
After that I try like this :
prd176> ALTER ROLLBACK SEGMENT RBS_04 STORAGE (MAXEXTENTS 65530);
ALTER ROLLBACK SEGMENT RBS_04 STORAGE (MAXEXTENTS 65530)
*
ERROR at line 1:
ORA-02221: invalid MAXEXTENTS storage option value
What I have to do ?
Please give solution , means complete command ?
here I am pasting my db information;
prd176> SELECT SEGMENT_NAME,TABLESPACE_NAME,FILE_ID,MAX_EXTENTS,MIN_EXTENTS
FROM DBA_ROLLBACK_SEGS
2 3 ;
Tablespace
SEGMENT_NAME Name FILE_ID MAX_EXTENTS MIN_EXTENTS
-------------------- -------------------- ---------- ----------- -----------
SYSTEM SYSTEM 1 505 2
RBS_01 ROLL_T01 2 32765 1
RBS_02 ROLL_T01 2 32765 1
RBS_03 ROLL_T01 2 32765 1
RBS_04 ROLL_T01 2 32765 1
Size of ROLL_T01 tablespace size is 1GB.
Please give me the complete solution?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|