Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: analyze a table ,but get a ORA-00959 & ORA-06512

Re: analyze a table ,but get a ORA-00959 & ORA-06512

From: gazzag <gareth_at_jamms.org>
Date: Wed, 12 Dec 2007 03:06:15 -0800 (PST)
Message-ID: <7f8ee1f5-939c-4e26-bb95-597d7cd615c4@i72g2000hsd.googlegroups.com>


On 12 Dec, 10:55, one..._at_gmail.com wrote:
> that's the problem:
> SQL> select temporary_tablespace from dba_users where
> username='SYSTEM';
>
> TEMPORARY_TABLESPACE
> ------------------------------
> TEMP
>
> so i change it :
> SQL> show user
> USER is "SYS"
> SQL> alter user system temporary tablespace tbs_temp;
>
> User altered.
>
> SQL> select temporary_tablespace from dba_users where
> username='SYSTEM';
>
> TEMPORARY_TABLESPACE
> ------------------------------
> TBS_TEMP
>
> but still got the error:
> SQL> exec dbms_stats.gather_table_stats(ownname => 'TAOBAO', tabname
> => 'BMW_GUEST', estimate_percent => 100, method_opt=> 'FOR ALL INDEXED
> COLUMNS');
> BEGIN dbms_stats.gather_table_stats(ownname => 'TAOBAO', tabname =>
> 'BMW_GUEST', estimate_percent => 100, method_opt=> 'FOR ALL INDEXED
> COLUMNS'); END;
>
> *
> ERROR at line 1:
> ORA-00959: tablespace 'TEMP' does not exist
> ORA-06512: at "SYS.DBMS_STATS", line 10301
> ORA-06512: at "SYS.DBMS_STATS", line 10315
> ORA-06512: at line 1
>
> did i miss some step ?- Hide quoted text -

Sorry, my fault. I meant, what does this query return:

select temporary_tablespace
from dba_users
where username = 'SYS';

HTH -g Received on Wed Dec 12 2007 - 05:06:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US