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: gazzag <gareth_at_jamms.org>
Date: Wed, 12 Dec 2007 02:28:24 -0800 (PST)
Message-ID: <14a4fdd2-d837-443f-accb-d469953abda8@s8g2000prg.googlegroups.com>


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 Received on Wed Dec 12 2007 - 04:28:24 CST

Original text of this message

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