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: <onedba_at_gmail.com>
Date: Wed, 12 Dec 2007 02:16:31 -0800 (PST)
Message-ID: <c288bfe7-b37f-46c3-b145-c8bd09472458@d27g2000prf.googlegroups.com>


On Dec 12, 5:47 pm, Mladen Gogala <mgog..._at_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. Received on Wed Dec 12 2007 - 04:16:31 CST

Original text of this message

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