-
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 ....
-
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"
-
Hi Sanjay,
PERMANENT : SAP Recommends that.
MOVE : Ok, I can delete that.
IS REST EVERYTHING IS FINE ! ! !! ! !!
Vijay
--------------------------
The Time has come ....
-
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"
-
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
-
Hi,
So I m taking that my procedure is right for doing such changes.
Vijay
--------------------------
The Time has come ....
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|