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

From: <onedba_at_gmail.com>
Date: Wed, 12 Dec 2007 02:55:35 -0800 (PST)
Message-ID: <a2463ed3-98cd-4d65-ad3b-cabad8dfeb34@b40g2000prf.googlegroups.com>

On Dec 12, 6:28 pm, gazzag <gar..._at_jamms.org> wrote:
> On 12 Dec, 10:16, one..._at_gmail.com wrote:
>
> > But，my db have the tbs_temp tablespace , it is the default temporary
> > tablespace .
>
> > DBMS_STATS should be use it but temp tablespace.
>
> What does the following query return?
>
> SQL> select temporary_tablespace
> from dba_users
> where username = 'SYSTEM';
>
> HTH
>
> -g

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 ? Received on Wed Dec 12 2007 - 04:55:35 CST