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
4293 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-32050: %s operation failed

1 Answers

ORA-01080: error in shutting down ORACLE

1 Answers

IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option

1 Answers

ORA-02844: Invalid value for the leave open flag

1 Answers

NNL-01075: Contact string

1 Answers

CLSR-00529: RACGONS: host and port number to be removed does not exist

1 Answers

ORA-12845: failed to receive interinstance parallel execution message

1 Answers

LSX-00230: invalid integer "~S"

1 Answers

ORA-32812: subscriber string does not exist

1 Answers

ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers

TNS-00547: user information retrieval failed

1 Answers

ORA-19665: size string in file header does not match actual file size of string

1 Answers

For more Oracle Errors Interview Questions Click Here