-
Permanent T/S into Temporary T/s??
Dear All,
I have a permanent tablespace that is empty. I would like to know if it is possible to convert this T/S into a temporary one and if possible, could anyone provide me with the command to do so..
Oracle Version is: 9i on solaris...
Regards,
K.Diwakar
-
-
Why not simply dorp the old tablespace and create a new temporary one? Seems the most straightforward way to me. And I assume you will want to use tempfiles for your temp tablespace, so the creation of the new tablespace will be lightening fast....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Dear Jmodic...
Thank u for ur answer.... Ur option seems to be the simplest. But is there a way of converting a permanent t/s into a temporary one... Yes (or)No will do....
Regards,
K.Diwakar
-
Code:
ALTER TABLESPACE "tablespace" TEMPORARY;
However this will only work on dictionary managed tablespaces, Use Jmodic's way for best results.
Last edited by jovery; 04-02-2003 at 04:19 AM.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Thank u Jovery,
I was wondering y this command (ALTER TABLESPACE "tablespace" TEMPORARY was not working for it use to work in Oracle 8.0.x.. and ur point makes it clear that this statement holds good for only Dictionary managed T/S.
Regards,
K.Diwakar
-
If you are using Oracle version 8.0.X, you should be having only Dictionary managed Tablespace. Locally Managed Tablespace were introduced only from Oracle 8i ( 8.1.5 and up).
Thanks.
-- Dilip
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
|