No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 900
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48741
Total active users1338
Act. users last 24h6
Act. users last hour0
Registered user hits last week145
Registered user hits last month435
Go up

how to add temp file in oracle 11g rac2 asm
Next thread: Golden gate monitoring script for struck processess
Prev thread: Multiple Connection DESCRIPTION in tnsnames.ora file

Message Score Author Date
hi, How to add temp file in oracle 11g r2 rac w...... mdsamiuddin shaikh Jan 16, 2014, 10:51
ALTER TABLESPACE ... ADD TEMPFILE ... Regards...... Michel Cadot Jan 16, 2014, 11:05
Thanx for responce.. i want to know in 11g r2 w...... mdsamiuddin shaikh Jan 16, 2014, 11:21
It's the same as Michal already showed you. You...... Adam Hudspith Jan 16, 2014, 12:55
Hi.. assuming your temporary tablespace name is...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts saumya das Jan 17, 2014, 06:36

Follow up by mail Click here

Subject: how to add temp file in oracle 11g rac2 asm
Author: mdsamiuddin shaikh, India
Date: Jan 16, 2014, 10:51, 3420 days ago
Os info: linux
Oracle info: 11g r2
Message: hi,

How to add temp file in oracle 11g r2 rac with asm.

pls let me know the steps and views


Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: how to add temp file in oracle 11g rac2 asm
Author: Michel Cadot, France
Date: Jan 16, 2014, 11:05, 3420 days ago
Message:
ALTER TABLESPACE ... ADD TEMPFILE ...

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: how to add temp file in oracle 11g rac2 asm
Author: mdsamiuddin shaikh, India
Date: Jan 16, 2014, 11:21, 3420 days ago
Message: Thanx for responce..

i want to know in 11g r2 with ASM..envirnment .


Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: how to add temp file in oracle 11g rac2 asm
Author: Adam Hudspith, United Kingdom
Date: Jan 16, 2014, 12:55, 3420 days ago
Message: It's the same as Michal already showed you.

You can specify the DG if you like... but as long as your database is setup properly that shouldnt be needed.

CREATE TEMPORARY TABLESPACE MY_TMP TEMPFILE '+DATA' SIZE 3G;

For example...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: how to add temp file in oracle 11g rac2 asm
Author: saumya das, India
Date: Jan 17, 2014, 06:36, 3420 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi..

assuming your temporary tablespace name is TEMP and tempfiles are located in TEMP diskgroup of ASM.please fire the below comand.

Alter tablespace temp add tempfile '+TEMP' size 1024M autoextend on next 32m.

The + symbol is important to add before diskgroup name otherwise the tempfile will be created in your local system.

Thanks
Saumya
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here