No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. PĂ©ran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour0
Registered user hits last week172
Registered user hits last month818
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, 380 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, 380 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, 380 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, 380 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, 373 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