Re: extents exxceeded ?? ( need help )

In article 10837_at_njitgw.njit.edu, yxc1612_at_hertz.njit.edu (yung-feng chang me stnt) writes:
>Dear netters:
>
> One user get following message while he is running a query.

                                                             ^^^^^

I'm about the make a assumtion based on the original post, if it is wrong please ignore the rest of this reply. :-}

Your are getting this error on a query no updates/inserts. (Assumption)

The only tables that a query extents would be a sort table. If you can see that the TS is fragmented then you must be dealing with a TS that has regular files in it. The first thing to do is confirm all this via dba_users look at the TEMPORARY_TABLESPACE field. Idealy you want to create a temporary TS for exactly these kind of sorts with large initial/Next settings ie) 1M+.

Of course you still have to do something about the fragmented TS. If it is a regular TS export that data and recreate. But if it is the System tablespace you have to recreate the DB and make sure that no one is used SYSTEM as a TEMPORARY_TABLESPACE.

-- 
Regards, 

Lee E. Parsons                  		Baker Hughes Inteq, Inc
Oracle Database Administrator 			lparsons_at_exlog.com