-
TEMP Tablespace
let's say we have users online using the database and I drop the TEMP tablespaces and recreate it.
what happened if I dropped the TEMP tablespace while the user online???
thanks
-
-
ON 9I,
you can't drop the default temporary tablespace so you have to create another one and issue:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE NEW_TEMP;
ONCE YOU DO THAT, all of the users should be default to the new temp and now you are free to drop the old one.
IS IT TRUE, Jeff???????
-
I wouldn't know the answer to that. I wouldn't ever drop my temporary tablespace.
Jeff Hunter
-
what's the consequnces of droppping the TEMP, Jeff.
I have tested it and it worked fine; however, I want to be sure that I can get some opinion in here specially someone like you.
thanks
-
Originally posted by learning_bee
what's the consequnces of droppping the TEMP, Jeff.
by this u will suerly not corrupt the DB, but the Q is why?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by learning_bee
what's the consequnces of droppping the TEMP, Jeff.
Your users can't sort
Jeff Hunter
-
You can create a new temp tablespace, change the temp tablespace to this, and then try to drop the first, but you'll have to be pacient, it will not happen immediatly unless no operations in course.
I think I've done this once...
ovidius over!
-
Hi,
I was experienced that if u don't check first in dba_segments
that the temporary tablespace is clean from temporary segments and you drop the tablespace when it contains temporary segments ,your database suppose to crash casuse to SMON crash.
Be careful!!
Nir
-
Is it..?
I took one rollbacksegment with large active transaction,
to offline, still oracle allowed me ( I think it wrote the
active "rollback information" to somewhereelse).
What is wrong in expecting oracle to act same like Rollback
on Temporary also?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|