Dear Gurus,
Could you please help me out with this - I want to increase the maxextents of below segment.
TIA,
SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS
2 from dba_segments
3 where ((max_extents-extents)/max_extents)*100 <40 and max_extents != 0
4 /
OWNER SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS
------ --------------- ------------------ ---------- -----------
SYS SYSTEM ROLLBACK 505 505
SQL> connect sys
Enter password:
Connected.
SQL> alter ROLLBACK sys.system storage (maxextents 1024);
alter ROLLBACK sys.system storage (maxextents 1024)
*
ERROR at line 1:
ORA-01902: SEGMENT keyword expected
TIA
Jonny
Get a bigger mailbox -- choose a size that fits your needs.
http://uk.docs.yahoo.com/mail_storage.html