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: How could I move the temp datafile?

Re: How could I move the temp datafile?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 20 Feb 2006 19:20:06 +0100
Message-ID: <dtd0h6$shs$1@news1.zwoll1.ov.home.nl> 





sybrandb_at_yahoo.com wrote:


> begin

> for i in (select username from dba_users) loop

> execute immediate 'alter user '||i.username||' temporary tablespace




Not in 8.0.5: no execute immediate


You could spool the output to a file, and execute the
spooled statements.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...


Received on Mon Feb 20 2006 - 12:20:06 CST












Original text of this message













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