Re: Analyze Schema failed

It needs temp space to write the changes. When it is done, the space becomes permanent. Try making you system tablespace bigger.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 24, 2001 11:45 AM

> I am not analyzing SYSTEM Schema. I thought analyze updates stats in Data
Dictionery. Only 12MB of 160MB was occupied in System TS.
> I had System TS in Auto Extend mode upto 200MB, but it did not extend. So
I am confused whether really it needs more space in System
> TS
>
> Thanks
> Deen
>
> -----Original Message-----
> Gramolini
> Sent: Monday, September 24, 2001 11:05 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Are you trying to analyze the system schema? If you are, don't. It can
> cause problems with all kinds of things. If you are not trying to analyze
> the system schema then just make your system tablespace bigger. You can
> either increase the size of existing datafile(s) or add a datafile.
>
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, September 24, 2001 10:25 AM
>
>
> > Hi gurus,
> >
> > Good Morning,
> >
> >
> > I tried to execute
> sys.dbms_utility.analyze_schema('XXXX','COMPUTE',method_opt=>'FOR ALL
> COLUMNS');
> >
> > I got the following error after 3 minutes.
> >
> > ORA-01652: unable to extend temp segment by 8091 in tablespace SYSTEM
> > ORA-06512: at "SYS.DBMS_UTILITY", line 232
> > ORA-06512: at line 2
> >
> > Does it mean, it requires more space in System Tablespace. I had enough
> space in System. I have a dedicated Temporary Tablespace.
> >
> > I do not know why it requires temp segment in System TS. If I understand
> correctly, it does some sorting which might require temp
> > segments which should come out of Temp TS.
> >
> > Can any body explain me this error
> >
> > Thanks
> > Deen
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Deen Dayal
> > INET: ddayal_at_dol.state.nj.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deen Dayal
> INET: ddayal_at_dol.state.nj.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).