Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NNO-00068: warning: administrative region check failed, next check in number seconds

1 Answers  


QSM-00770: the specified workload string is already referenced by task string

1 Answers  


ORA-07237: slemcl: invalid file handle, seals do not match.

1 Answers  


ORA-02261: such unique or primary key already exists in the table

1 Answers  


ORA-24338: statement handle not executed

1 Answers  






ORA-25508: database is not mounted

1 Answers  


RMAN-06536: BACKED UP ... TIMES option is supported only for archived logs

1 Answers  


NNL-00993: Auto-refresh failure retry expiration: string

1 Answers  


ORA-12473: The procedure is disabled when Label Security is used with OID.

1 Answers  


RMAN-06606: RMAN configuration parameters are successfully reset to default value

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  






Categories