DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Permanent T/S into Temporary T/s??

  1. 04-02-2003, 02:13 AM #1
    diwakar
    diwakar is offline Member
    Join Date
    May 2002
    Posts
    193

    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
    Reply With Quote Reply With Quote
  2. 04-02-2003, 02:44 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tahiti.oracle.com
    Reply With Quote Reply With Quote
  3. 04-02-2003, 03:06 AM #3
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?
    Reply With Quote Reply With Quote
  4. 04-02-2003, 04:11 AM #4
    diwakar
    diwakar is offline Member
    Join Date
    May 2002
    Posts
    193
    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
    Reply With Quote Reply With Quote
  5. 04-02-2003, 04:15 AM #5
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!
    Reply With Quote Reply With Quote
  6. 04-03-2003, 02:44 AM #6
    diwakar
    diwakar is offline Member
    Join Date
    May 2002
    Posts
    193
    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
    Reply With Quote Reply With Quote
  7. 04-03-2003, 09:56 AM #7
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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