No question at this time
DBA Top 10
1 B. Vroman 14600
2 M. Cadot 11000
3 J. Schnackenberg 8200
4 T. Boles 7950
5 A. Kavsek 6200
6 M. Hidayathullah ... 2200
7 G. Lambregts 1100
8 T. P 1000
9 P. Wisse 900
10 B. Derous 500
10 . Lauri 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48286
Total active users1591
Act. users last 24h3
Act. users last hour0
Registered user hits last week242
Registered user hits last month1121
Go up

getting temp tablespace error while inserting data in a table
Next thread: Large volume of data in inserting in our database.
Prev thread: Flash backup restore on oracle12c rac environment with dataguard 2 node rac

Message Score Author Date
While inserting the 190 GB data in a table from ba...... rahul reddy Sep 04, 2018, 21:04
Remove parallel or increase temp size. Regard...... Michel Cadot Sep 04, 2018, 21:43
temp tablespace is already 250 GB.How much more I ...... rahul reddy Sep 04, 2018, 22:08
<i>How much more I need to increase its size ? <...... Michel Cadot Sep 05, 2018, 08:09
What is your INSERT statement? It's sorting opera...... Gareth Graham Sep 12, 2018, 12:00

Follow up by mail Click here


Subject: getting temp tablespace error while inserting data in a table
Author: rahul reddy, India
Date: Sep 04, 2018, 21:04, 75 days ago
Os info: AIX
Oracle info: 12c
Error info: unable to extend temp tablespace
Message: While inserting the 190 GB data in a table from backup table getting the temp tablespace error.

Even enabled parallel DML parameter before inserting data.

Am inserting 190 GB data and temp tablespace size is 250 GB.But why am getting this error ?

Please provide any suggestions to get this done.

Thanks.


Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: getting temp tablespace error while inserting data in a table
Author: Michel Cadot, France
Date: Sep 04, 2018, 21:43, 75 days ago
Message:
Remove parallel or increase temp size.

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: getting temp tablespace error while inserting data in a table
Author: rahul reddy, India
Date: Sep 04, 2018, 22:08, 75 days ago
Message: temp tablespace is already 250 GB.How much more I need to increase its size ?
If I remove parallel DML ,it gonna take more time for insert ?

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

Subject: Re: getting temp tablespace error while inserting data in a table
Author: Michel Cadot, France
Date: Sep 05, 2018, 08:09, 74 days ago
Message:
How much more I need to increase its size ?

No one can answer this, this is your table and data. You want to be sure, double it.

If I remove parallel DML ,it gonna take more time for insert ?

Most likely.

I gave you the alternative you have, pick up the way you want.

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: getting temp tablespace error while inserting data in a table
Author: Gareth Graham, United Kingdom
Date: Sep 12, 2018, 12:00, 67 days ago
Message: What is your INSERT statement? It's sorting operations that consume TEMP.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here