Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
Check UNDO tablespace.if full increase the the PSAPUNDO tablespace, if same error repeats again and again with UNDO tablespace getting full repeatedly then other option can be done is to reduce the undo retention period to some lesser value.
---------------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
| | Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
