ORA-30082: datetime/interval column to be modified must be empty to decrease fr

ORA-30082: datetime/interval column to be modified must be
empty to decrease fractional second or leading field precision

Question Posted / guest

1 Answers
4257 Views
I also Faced
E-Mail Answers

ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or l..

Answer / guest

Cause: datetime/interval column with existing data is being
modified to decrease fractional second or leading field
precisions.

Action: Such columns are only allowed to increase the
precisions.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36278: (XSCGMDLAGG07) workspace object is not a valid valueset.

1 Answers

ORA-32695: HTI: Not enough memory

1 Answers

LPX-00280: HTTP error ~s

1 Answers

TNS-00530: Protocol adapter error

1 Answers

ORA-10919: Default temporary tablespace group must have at least one tablespace

1 Answers

AMD-00160: Warning! Exceeded maximum Custom Measure number of "string"

1 Answers

ORA-14022: creation of LOCAL partitioned cluster indices is not supported

1 Answers

ORA-30451: internal error

1 Answers

ORA-36314: (PHYS01) workspace object must be a dimension, relation or variable.

1 Answers

RMAN-07508: cataloging done

2 Answers Excellence, TCS,

ORA-02844: Invalid value for the leave open flag

1 Answers

TNS-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers

For more Oracle Errors Interview Questions Click Here