Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!d27g2000prf.googlegroups.com!not-for-mail
From: onedba@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: analyze a table ,but get a ORA-00959 & ORA-06512
Date: Wed, 12 Dec 2007 02:16:31 -0800 (PST)
Organization: http://groups.google.com
Lines: 16
Message-ID: <c288bfe7-b37f-46c3-b145-c8bd09472458@d27g2000prf.googlegroups.com>
References: <884cac7b-d626-4a43-8f72-63b4b69089f9@s12g2000prg.googlegroups.com> 
 <475fae16$0$1340$834e42db@reader.greatnowhere.com>
NNTP-Posting-Host: 121.0.31.121
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197454592 3534 127.0.0.1 (12 Dec 2007 10:16:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Dec 2007 10:16:32 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d27g2000prf.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:438977
X-Received-Date: Wed, 12 Dec 2007 05:16:32 EST (text.usenetserver.com)

On Dec 12, 5:47 pm, Mladen Gogala <mgog...@yahoo.com> wrote:
> On Wed, 12 Dec 2007 00:26:35 -0800, onedba wrote:
> > My db don't have the temp temporary tablespace .
>
> Well, create one. Statement goes something like this:
>
> ALTER DATABASE LET THERE BE TEMPORARY TABLESPACE TEMPFILE.....
>
> --
> Mladen Gogala


But，my db have the tbs_temp tablespace , it is the default temporary
tablespace .

DBMS_STATS should be use it but temp tablespace.