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
4315 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-02490: missing required file size in RESIZE clause

1 Answers

TNS-00234: Connect data for failed call: CALL DATA = string RECEIVE DATA = :string:

1 Answers

ORA-02212: duplicate PCTFREE option specification

1 Answers

NZE-29158: Unable to open library.

1 Answers

CLSR-01004: Failed to mount database

1 Answers

NNL-00297: Cache will be dumped to trace file in string

1 Answers

ORA-02757: osnfop: fork_and_bind failed

1 Answers

KUP-04017: OS message: string

1 Answers

RMAN-03033: current log archived

1 Answers

TNS-04069: Sleeping for number seconds...

1 Answers

ORA-02434: cannot enable unique(string) - unique key not defined for table

1 Answers

ORA-19901: database needs more recovery to create new incarnation

1 Answers

For more Oracle Errors Interview Questions Click Here