Dropping and Creating new Temporary Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Dropping and Creating new Temporary Tablespace

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Dropping and Creating new Temporary Tablespace

    Hi,

    I have a temporary tablespace of size 1.73GB. It consists of 2 datafiles. With st parameters init 1M, next 1 M, Min Ext 1 , Max Ext Unlimited.


    Now I wanna configure parameters according to my SORT_AREA_SIZE parameters.

    So the process I m thinking is as below :

    1. Bring Down all applications (I am running SAP)
    2. Connect to Oracle
    3. Alter tablespace PSAPTEMP Offline
    4. DROP tablespace PSAPTEMP including contents;
    5. Move the old files from original location
    6. CREATE the PSAPTEMP tablespace
    7. Create Tablespace PSAPTEMP datafile
    'M:\oracle\P62\SAPDATA1\TEMP_1\TEMP.DATA1' size 1572768K
    default storage (initial 2064K
    next 2064K
    minextents 1
    pctincrease 0)
    PERMANENT;

    8. Alter tablespace PSAPTEMP Online;


    Am I doing the it right, or some changes need to be made. This is production database.


    Any Views . . . . . . . . .

    Regards
    Vijay
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    6. Why move? You can delete them.

    7. Why would you want a TEMP tablespace to be created as PERMANENT ??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi Sanjay,

    PERMANENT : SAP Recommends that.

    MOVE : Ok, I can delete that.

    IS REST EVERYTHING IS FINE ! ! !! ! !!

    Vijay
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by vijay8282
    PERMANENT : SAP Recommends that.
    I really hate such recommendations from third party software vendors.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    you hate it or not..you better follow their recommendations..otherwise support will be a issue..you can take such risks with test environments..but not production

    regards
    Hrishy

  6. #6
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    So I m taking that my procedure is right for doing such changes.

    Vijay
    --------------------------
    The Time has come ....

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Dropping and Creating new Temporary Tablespace

    Originally posted by vijay8282
    7. Create Tablespace PSAPTEMP datafile
    'M:\oracle\P62\SAPDATA1\TEMP_1\TEMP.DATA1' size 1572768K
    default storage (initial 2064K
    next 2064K
    minextents 1
    pctincrease 0)
    PERMANENT;


    Any Views . . . . . . . . .
    You could create a LMT tablespace instead of a DMT temporary tablespace. Check this out...

    http://technet.oracle.com/docs/produ...paces.htm#9566

    HTH.

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