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

On 12 Dec, 11:21, one..._at_gmail.com wrote:
> thank you and i am so stupid。
>
> SQL> select username,temporary_tablespace from dba_users;
>
> USERNAME TEMPORARY_TABLESPACE
> ------------------------------ ------------------------------
> SYS TEMP
> SYSTEM TBS_TEMP
> DBSNMP TEMP
> TAOBAO TBS_TEMP
> JIVE TBS_TEMP
> PERFSTAT TBS_TEMP
> TBUSER TBS_TEMP
> TEST TBS_TEMP
> APAY TBS_TEMP
> DBFLASH TBS_TEMP
> OUTLN TEMP
> WMSYS TEMP
>
> then, i changed them all, and it's ok.
>
> But I have another question, if a user's default temporary tablespace
> were dropped , I think Oracle should use the db's default temporary
> tablespace as the user's , but actually it doesn't.
>
> excuse my poor English !
>
> thank you !- Hide quoted text -
>

If I recall correctly, a temporary tablespace cannot be dropped while it is a user's default.

Anyway, glad to help. You don't need to excuse your English, it's fine :)

-g Received on Wed Dec 12 2007 - 05:35:51 CST