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-07629: smpall: $EXPREG failure

1 Answers  


ORA-06407: NETCMN: unable to set up break handling environment

1 Answers  


ORA-38606: FI support threshold not between [0, 1]

1 Answers  


ORA-32600: RETENTION and PCTVERSION cannot be used together

1 Answers  


LPX-00232: invalid use of a parameter entity reference

1 Answers  






ORA-24066: invalid privilege specified

1 Answers  


ORA-27469: %s is not a valid string attribute

1 Answers  


EXP-00102: Resumable parameters ignored -- current session not resumable

1 Answers  


ORA-23492: no new sites for extension request "string"

1 Answers  


ORA-27156: request for process information failed

1 Answers  


PCC-02319: expression type does not match usage

1 Answers  


ORA-08003: sequence string.NEXTVAL exceeds internal limits

1 Answers  


Categories