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 -> analyze a table ,but get a ORA-00959 & ORA-06512

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

From: <onedba_at_gmail.com>
Date: Wed, 12 Dec 2007 00:26:35 -0800 (PST)
Message-ID: <884cac7b-d626-4a43-8f72-63b4b69089f9@s12g2000prg.googlegroups.com>


a simple anzlyze :
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

My db don't have the temp temporary tablespace .

SQL> select * from database_properties where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE'; PROPERTY_NAME

PROPERTY_VALUE                                     DESCRIPTION
------------------------------
--------------------------------------------------
--------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TBS_TEMP                                           Name of default
temporary tablespace

SQL> select tablespace_name,contents from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME                CONTENTS
------------------------------ ---------
TBS_TEMP                       TEMPORARY

please tell me ,why ?

thank you ! Received on Wed Dec 12 2007 - 02:26:35 CST

Original text of this message

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