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

NZE-28829: no cipher type specified

1 Answers  


LPX-00211: attribute default must be REQUIRED, IMPLIED, or FIXED

1 Answers  


NNO-00712: warning: group string cache checkpoint failed

1 Answers  


IMG-00579: extra quantize argument

1 Answers  


ORA-02215: duplicate tablespace name clause

1 Answers  






ORA-06123: NETTCP: cannot set KEEPALIVE

1 Answers  


ORA-23475: key column string must be sent and compared

1 Answers  


SQL*Loader-00565: unexpected error during skip .

1 Answers  


ORA-23348: cannot replicate procedure string; only IN parameters supported

1 Answers  


PCC-00089: Invalid Oracle TYPE specification

1 Answers  


TNS-04011: Oracle Connection Manager instance not yet started.

1 Answers  


ORA-24303: call not supported in non-deferred linkage

1 Answers  


Categories