Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: who is using sort space?
Phil Cook <pcook_at_iamerica.net> wrote in article
<01bca3a0$9e8f0840$92f9adcd_at_phil-cook-laptp>...
> Look in all_tables where tablespace = 'TEMP'
>
> Phil Cook
Yes, but SYS owns them all!
Scott Overby E-mail scott.overby_at_sdsdata.com Sr. Systems Analyst Phone (414) 459-7999 Strategic Data Systems FAX (414) 459-9123 615 Penn Ave.