No question at this time
DBA Top 10
1 M. Cadot 7200
2 B. Vroman 3100
3 J. PĂ©ran 2100
4 A. Kavsek 1400
5 P. Tsongayinwe 1300
6 P. Wisse 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48684
Total active users1329
Act. users last 24h2
Act. users last hour0
Registered user hits last week44
Registered user hits last month235
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, 3135 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, 3135 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, 3135 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, 3135 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, 3134 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