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

Thread: temporary to permanant

  1. #1
    Join Date
    Aug 2000
    Posts
    29
    Does anybody know how to make a temporary
    tablespace in Oracle 8.1.6 to permanant using
    the command line?
    I would have thougt to change it, it would be:
    ALTER TABLESPACE <<name>> TEMPORARY;
    but this does not work

    any help would be greatly appeciated

    thanks,
    scotta


    J.Scott Adams

  2. #2
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi there scotta

    You can simply use the command

    ALTER TABLESPACE ts_name PERMANENT;

    Hope this helps

    Alison

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Can u send me the script which u wrote inorder to create the temporary tablespace.Please send me the entire command for that tablespace at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP
    rohitsn@altavista.com


    [QUOTE][i]Originally posted by scotta [/i]
    [B]Does anybody know how to make a temporary
    tablespace in Oracle 8.1.6 to permanant using
    the command line?
    I would have thougt to change it, it would be:
    ALTER TABLESPACE <<name>> TEMPORARY;
    but this does not work

    any help would be greatly appeciated

    thanks,
    scotta


    [/B][/QUOTE]

  4. #4
    Join Date
    Feb 2001
    Posts
    184
    There are Restriction in Changing the TS. It should not have Permanent Objects if Turning to Temp and the Status should be Offline before Changing from Temp to Perm or Vice Versa.

    Thanks

  5. #5
    Join Date
    Aug 2000
    Posts
    29
    here is the script I used in making this tablespace

    CREATE TABLESPACE y2001 DATAFILE 'E:\ORANT\DBS\y2001.DBS' SIZE 500M;
    GRANT DBA,CONNECT,RESOURCE TO y2001 IDENTIFIED BY y2001;
    ALTER USER y2001 DEFAULT TABLESPACE y2001 TEMPORARY TABLESPACE TEMPORARY_DATA;
    J.Scott Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width