Re: changing temporary tablespace for all schemas

From: Myron Wintonyk <Myron.Wintonyk_at_UAlberta.ca>
Date: Mon, 2 Apr 2001 08:57:20 +1000
Message-ID: <9a8bu2$kfm$1@kraken.itc.gu.edu.au>

I missed the first part of this post, but from the title, you could simply create a series of SQL statements to change each user. This shoud work:

select 'alter user ' || usename || ' temporary tablespace NEWTABLESPACE;' from dba_users where username not in ( 'SYS','SYSTEM' );

"Jose Nicolau" <jose.nicolau_at_clix.pt> wrote in message news:3AC53E71.F5353179_at_clix.pt...
> 7.3? glup! Sorry, I think not.
>
> Cristian Veronesi wrote:
>
> > Jose Nicolau wrote:
> >
> > > Why don't you resize the datafile of your bigtemp tablespace?
> >
> > Is it possible in Oracle 7.3.4?
> >
> > Thank you.
> > Best regards, Cristian
> >
> > --
> > Cristian Veronesi ><((((º> http://www.crpa.it
> >
> > "Ogni limite ha una pazienza" (A. De Curtis)
>
Received on Sun Apr 01 2001 - 17:57:20 CDT