Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_REDEFINITION.START_REDEF_TABLE ORA-12008 ORA-04030

AleCApr 22 2011 — edited Apr 27 2011
RDBMS: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
OS: Redhat 4.6

I'm trying to migrate to a partitioned table using the DBMS_REDEFINITION.

But I've an error:
BEGIN DBMS_REDEFINITION.START_REDEF_TABLE('m', 'ij', 'ij_tmp', NULL, DBMS_REDEFINITION.cons_use_pk, 'LIID, ID'); END;

*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-04030: out of process memory when trying to allocate 262656 bytes
(callheap,kllcqgf:kllsltba)
ORA-06512: at "SYS.DBMS_REDEFINITION", line 40
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1035
ORA-06512: at line 1
The table size is 3648Mb and the memory parameters are:

- db_cache_size = 629145600
- shared_pool_size = 734003200
- pga_aggregate_target = 524288000

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 25 2011
Added on Apr 22 2011
#general-database-discussions
1 comment
818 views