UNDO TABLESPACE
Moderators: chulett, rschirm, roy
UNDO TABLESPACE
Hi Friends,
Im loading flat file to Target table oracle, I am getting this error can anyone help me please.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDO1'
and the job gets aborted.
Im loading flat file to Target table oracle, I am getting this error can anyone help me please.
ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDO1'
and the job gets aborted.
chulett wrote:Talk to your DBA. They may need to increase that tablespace or you may need to commit more often. Or perhaps just wait and try again. ...
Thanks Chulett, I have even asked my DBA to increase the table space but that didnt work work out still getting the same error .
And I have tried running it lot of times.
Any other alternate would help me a lot.
Thanks
Flat file size is around 4678712 bytes, Im just loading into target(straight Load) with a transformer stage in between flat file and target(oracle OCI stage version 2) written a custom INSERT query in the target which also consists of SEQUENCE.next val for generating sequence numbers for one field.chulett wrote:Then they didn't increase it enough.![]()
How big is your flat file? What kind of "load" are you doing? ...
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Decrease transaction size (rows per transaction) to, say, 50. If the UNDO tablespace is OK after that, try increasing by a factor of 2 until the problem recurs, then back off till it disappears again.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.