Solved

dbms_redefinition error

Posted on 2007-03-20
1
897 Views
Last Modified: 2013-12-19
Getting this error when trying to use dbms_redefinition package.

SQL> execute dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging');

BEGIN dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging'); END;

 

*

ERROR at line 1:

ORA-12008: error in materialized view refresh path

ORA-01632: max # extents (4096) reached in index

CSUH_CUSTOM.ACTIVITY_ACCUMULATOR_PK_NEW

ORA-06512: at "SYS.DBMS_REDEFINITION", line 8

ORA-06512: at "SYS.DBMS_REDEFINITION", line 146

ORA-06512: at line 1

 What steps should i take now?
0
Comment
Question by:xoxomos
1 Comment
 
LVL 7

Accepted Solution

by:
Fayyaz earned 250 total points
ID: 18762369
First you have to stop the redefinition process using
dbms_redefinition.finish_redef_table or
dbms_redefinition.abort_redef_table
Then you have to correct the error of max extents in your index CSUH_CUSTOM.ACTIVITY_ACCUMULATOR_PK_NEW
Increase the max extents using ALTER INDEX .... STORAGE command to a reasonable value and start the redefinition process again
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 36 84
How to count the number of rows in multiple Oracle Tables 10 64
Oracle Syntax 8 56
PL/SQL Search for multiple strings 5 42
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now