No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7000
3 B. Vroman 6000
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3000
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h9
Act. users last hour1
Registered user hits last week188
Registered user hits last month1051
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, 259 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, 259 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, 259 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, 258 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, 251 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