ORA-01463: cannot modify column datatype with current
constraint(s)



ORA-01463: cannot modify column datatype with current constraint(s)..

Answer / guest

Cause: An attempt was made to modify the datatype of column
which has referential constraints; or has check constraints
which only allows changing the datatype from CHAR to VARCHAR
or vise versa.

Action: Remove the constraint(s) or do not perform the
offending operation.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00154: attribute "use" must have its value set to "optional"

1 Answers  


ORA-02255: obsolete 7.1.5

1 Answers  


ORA-12412: policy package string is not installed

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


ORA-32840: property name cannot be NULL

1 Answers  






ORA-01091: failure during startup force

1 Answers  


ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specifed when creating any non-surrogate grouping id.

1 Answers  


NCR-04007: NCRR: Invalid object handle

1 Answers  


ORA-26725: cannot downgrade apply handlers

1 Answers  


SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used

1 Answers  


RMAN-08122: keep attributes for the backup are changed

1 Answers  


NZE-29154: deterministic RNG self-test failure

1 Answers  


Categories