Home » Developer & Programmer » Data Integration » Issue with UNdo Talespace
Issue with UNdo Talespace [message #352438] Tue, 07 October 2008 11:36 Go to next message
ma12
Messages: 2
Registered: October 2008
Junior Member
Hello,

In our application we have an inbuilt data mart ETL process which is scheduled to run daily nightly.The application is failing with error UNDO tablespace. When we run the extract manually in the morning it runs fine.

Other than keep increasing the UNDO space which eventually will cause the error in REDO space is there any other option for this.

We have increased the table space couple of times as a temporary solution. We have a data of 645.37 MB and UNDO tablespace of 9GB. We are on oracle 10G version.

Thanks,
Ma
Re: Issue with UNdo Talespace [message #352475 is a reply to message #352438] Tue, 07 October 2008 23:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which error? Full message.
Which Oracle version? Full number.

Regards
Michel
Re: Issue with UNdo Talespace [message #352585 is a reply to message #352475] Wed, 08 October 2008 08:20 Go to previous messageGo to next message
ma12
Messages: 2
Registered: October 2008
Junior Member
ERROR: ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTS', PSP_INSERT_SST_INITIAL

and Oracle version 10.1.0.4.

Thanks,

[Updated on: Wed, 08 October 2008 08:21]

Report message to a moderator

Re: Issue with UNdo Talespace [message #352600 is a reply to message #352585] Wed, 08 October 2008 09:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
* check if some session didn't forget to commit
* increase undo tablespace size
* don't use GUARANTEE option on undo tablespace
* decrease undo_retention parameter

These are the options you have.

Regards
Michel

[Updated on: Wed, 08 October 2008 09:37]

Report message to a moderator

Previous Topic: JOINS
Next Topic: Connecting to SQL Server and extracting meta data
Goto Forum:
  


Current Time: Thu Mar 28 09:55:49 CDT 2024