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: alter table move into temporary tablespace.

Re: alter table move into temporary tablespace.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 13 Dec 2002 19:41:05 +0100
Message-ID: <3dakvu814umfj92e2t9jt98eatojt6j27j@4ax.com> 





On Fri, 13 Dec 2002 17:56:01 GMT, "Charles J. Fisher"
<cfisher_at_rhadmin.org> wrote:



>alter tablespace temp temporary

>*

>ERROR at line 1:

>ORA-01662: tablespace 'TEMP' is non-empty and cannot be made temporary

>

>How can I correct this?





By moving the permanent objects like tables and indexes out of the
TEMP tablespace or just drop them.




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Fri Dec 13 2002 - 12:41:05 CST












Original text of this message













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