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

ORA-32103: error from OCI call

1 Answers  


PLS-00638: cannot overload MAP method

1 Answers  


TNS-12661: Protocol authentication to be used

1 Answers  


DRG-10848: invalid structured clause

1 Answers  


ORA-38472: VARCHAR representation of the data item is too long.

1 Answers  






ORA-36882: (XSSRF01) The second parameter of an AW single row function cannot be NULL.

1 Answers  


ORA-07639: smscre: SGA pad area not large enough (string bytes required)

1 Answers  


NZE-28819: No distinguished name provided.

1 Answers  


ORA-09954: scgcc: unexpected return status to callback of lock close

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


QSM-02187: materialized view on external table

1 Answers  


ORA-12554: TNS:current operation is still in progress

1 Answers  


Categories