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

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