Re: Help!! Max extents exceeded - Urgent

Joanna Lee <joanna_at_scotts.com.sg> wrote:

]Hi
]
] My company is using oracle version 6. My colleague encountered
]an error ora-01556 which says : max number of 40 extents exceeded. Can
]anybody tell me how big is the 40? is it 40M or 400M? I've increased the
]tablespace to 140M but to no avail. Can somebody help me? Thanks.
]

As Neil said in another post, alter table .... storage (maxextents 60); but you should also schedule a re-org of the table and check your other tables and indexes.

-- 
 ,-,_|\   George Dau,                                             __
/    * \  Unix (Solaris, DEC Unix, Linux), NT, Oracle, Internet. (OO)
\_,--\_/  Home: gedau_at_pobox.com          Work: gedau_at_mim.com.au ( \/ )
      v   WWW:  http://pobox.com/~gedau                          W--W

Food for spambots: 
kittycat_at_speedmatrix.com sharon822_at_gracefully.com lisa_at_ix.netcom.com
scoop_at_skynet.net.au wayne_at_inreach.com webmaster_at_arabicnews.com 
macs_at_lostvegas.com editors_at_arabicnews.com comments_at_arabicnews.com
subscription_at_arabicnews.com ;-) imsco_at_acceptcards.com
upstart_9_at_hotmail.com insider_at_insidernet.com insider_at_insidermall.com