It will alter all of your users to the new tspace name except sys and
system....they should remain is system tablespace for their default.
You should now be able to just drop the current temporary tablespace.
Of course, it will not drop as long as a user is currently using
it...either wait on those users or kill their session...or bounce the
DB if you have that luxury, to kick them out. =20
9.2.0.1 on W2K Advanced Server. no they are not set to "default:
On Sun, 9 Jan 2005 13:06:44 -0600, Hollis, Les <Les.Hollis@(protected) >
wrote:
> What version? Are you using "default " temporary tablespace if on 9i?
--
http://www.freelists.org/webpage/oracle-l
