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 03:35:51 -0800 (PST)
Message-ID: <7250974e-b11a-4968-bbbd-dd10825b1663@w40g2000hsb.googlegroups.com>


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

Original text of this message

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