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
4233 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-19831: incompatible string.string.string DBMS_BACKUP_RESTORE package: string.string.string required

1 Answers

ORA-02289: sequence does not exist

1 Answers

PLS-00486: select list cannot be enclosed in parentheses

1 Answers

ORA-07626: smsget: sga already mapped

1 Answers

ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers

1 Answers

ORA-31674: worker process interrupt for unhandled exception in master process

1 Answers

ORA-24143: invalid evaluation context name

1 Answers

ORA-26668: STREAMS process string exists

1 Answers

TNS-01101: Could not find service name string

1 Answers

LFI-01006: File ends in partial character in string.

1 Answers

PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character

1 Answers

ORA-31686: error creating worker processes

1 Answers

For more Oracle Errors Interview Questions Click Here