Re: changing temporary tablespace for all schemas

Why don't you resize the datafile of your bigtemp tablespace?

Cristian Veronesi wrote:

> Hello.
> All my schemas use an over-dimensioned temporary tablespace called
> BIGTEMP and I have to free some space on the HD, so I wish to make them
> to use a smaller temporary tablespace called SMALLTEMP instead.
> Please let me know if these steps are correct (Oracle 7.3):
>
> 1. for each schema, issue the command: ALTER USER ... TEMPORARY
> TABLESPACE SMALLTEMP ;
> 2. ALTER TABLESPACE BIGTEMP OFFLINE ;
> 3. delete BIGTEMP datafile (gulp!)
>
> TIA, Cris
>
> --
> Cristian Veronesi ><((((º> http://www.crpa.it
>
> "Ogni limite ha una pazienza" (A. De Curtis)
Received on Sat Mar 24 2001 - 16:06:11 CST