PL/SQL (MOSC)

MOSC Banner

Problem with DBMS_REDEFINITION.START_REDEF_TABLE using a SEQUENCE

edited Oct 20, 2011 7:59AM in PL/SQL (MOSC) 10 commentsAnswered ✓
Hi eveyrone,
I try to use the DBMS_REDEFINITION package for the first time.

When I try to use an Oracle SEQUENCE in the column mapping string I receive an error :

Rapport d'erreur :
ORA-42008: une erreur s'est produite au cours de l'instanciation de la redéfinition
ORA-12018: l'erreur suivante est survenue pendant la génération du code pour "BRUNCARL"."T_REDEF_1_INTERIM"
ORA-00917: virgule absente
ORA-06512: à "SYS.DBMS_REDEFINITION", ligne 52
ORA-06512: à "SYS.DBMS_REDEFINITION", ligne 1634
ORA-06512: à ligne 7
42008. 0000 - "error occurred while instantiating the redefinition"
*Document: YES
*Cause: An error occurred while instantiating the online redefinition
which requires aborting the redefinition.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center