Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!s12g2000prg.googlegroups.com!not-for-mail
From: onedba@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: analyze a table ,but get a ORA-00959 & ORA-06512
Date: Wed, 12 Dec 2007 00:26:35 -0800 (PST)
Organization: http://groups.google.com
Lines: 39
Message-ID: <884cac7b-d626-4a43-8f72-63b4b69089f9@s12g2000prg.googlegroups.com>
NNTP-Posting-Host: 121.0.31.121
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197447995 14010 127.0.0.1 (12 Dec 2007 08:26:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Dec 2007 08:26:35 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: s12g2000prg.googlegroups.com; posting-host=121.0.31.121; 
 posting-account=Cw3VZwoAAADDYAP2SNKqjbaD60Zu-BDn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.8.1.11) 
 Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:438959
X-Received-Date: Wed, 12 Dec 2007 03:26:35 EST (text.usenetserver.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 !