i just did it... but it did not change the TEMPORARY_TABLESPACE
info in dba_users for SYS !!!
> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Sent: Tuesday, September 12, 2000 7:29 PM
> To: main oracle list; oracle dba list
> Subject: Temporary tablespace for SYS
>
> Hi All,
>
> I've got an email from someone who says that it used not to be possible to
> drop
> a tablespace that had ever been the temporary tablespace for SYS. This is
> news
> to me. Has anyone ever heard of this before?
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
> @
> @ Going to OpenWorld?
> @ Catch the Ixora performance tuning seminar too!
> @ See http://www.ixora.com.au/seminars/ for details.
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Tue Sep 12 2000 - 21:27:00 CDT
