Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
HI,
read SAP note 1045320 - ORA-30036 despite high number expired/unexpired undo extents.
---------------Original Message---------------
From: Palmintier
Sent: Wednesday, September 29, 2010 8:25 AM
Subject: Import cancelled due to lack of memory? ERROR: ORA-30036
> Hi,
>
> Yesterday I posted this problem already but somehow it was never listed so I will try again now.
>
> I imported a customizing transport and it was canceld with a return code 16. The Log Display shows this:
>
>
> While importing the LOG Start import R3TRTABUATXKO ...
> table ATXKO: entry in DB is 88 bytes bigger than in file.
> ... ignoring such differences.
> No memory for space allocation (440000000)
> twrtab reached memory limit; memory usage 435000000
> [dev trc ,00000] Mon Sep 27 16:27:33 2010 1556846598 10464.978128
> [dev trc ,00000] OCIStmtExecute() failed with -1=OCI_ERROR 158540 10465.136668
> [dev trc ,00000] Mon Sep 27 16:27:34 2010 4853 10465.141521
> [dev trc ,00000] SQL error 30036: 1062 10465.142583
> [dbsloci. ,00000] *** ERROR => Error 30036 in stmt_execute() from oci_execute_stmt(), orpc=0
> 0 10465.142583
> [dbsloci. ,00000] *** ERROR => ORA-30036 occurred when executing SQL stmt (parse error offset=12)
> 1535 10465.144118
>
> and after that it begins to repeat the following error over and over again untill it cancelles the import:
>
> SQL error 30036 accessing ATXKO: ORA-30036: unable to extend segment by 8 in undo t
> 28160 15175598
> 0 entries from ATXKO (100%) deleted.
> Duplicate Key error during insert into table ATXKO occured
>
> I read about enhancing memory and changing some paramaters but I have no clue where and how to change and to solve this problem.
>
> I hope someone can help out.
>
> Kind regards
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Snowy
SAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
