Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporary tablespace for SYS
I believe the claim was that this was true sometime in the past. It is
certainly not true now. About a week ago some developers working on a
nascent database called to say they had dropped too many tables. I
performed a point-in-time recovery, but forgot that locally managed
temporary tabespaces are not included in hot backups. The database opened
without incident, but very shortly afterwards my pager was receiving
messages, "Can't lock file ...". The old temporary tablespace file had been
deleted. Dropping and recreating the temporary tablespace fixed the problem.
This was sys's temporary tablespace.
Luckily, the first attempted use of the tablespace was by one of my database monitoring scripts. The developers never knew the problem existed. Although, I was pretty sure droppping and recreating the tablespace would fix the problem, I was very glad I had performed a cold backup whih included the "temp_file" before I started the point-in-time recovery.
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id]
Sent: Tuesday, September 12, 2000 7:27 PM
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_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
>
![]() |
![]() |