Message-Id: <10618.116808@fatcity.com>
From: "Steve Adams" <steve.adams@ixora.com.au>
Date: Wed, 13 Sep 2000 19:53:27 +1000
Subject: RE: Temporary tablespace for SYS

Hi Rahul,

I cannot reproduce that on 8.1.6.0.0 on NT.

@   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.


-----Original Message-----
From: Rahul [mailto:rahul@ratelindo.co.id]
Sent: Wednesday, 13 September 2000 12:27
To: 'Steve Adams'
Cc: 'Oracle List I'; 'Oracle List II'
Subject: RE: Temporary tablespace for SYS


i just did it... but it did not change the TEMPORARY_TABLESPACE
info in dba_users for SYS !!!

> ----------
> From: 	Steve Adams[SMTP:steve.adams@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@quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk