1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest


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

NZE-29156: conditional RNG self-test failure

1 Answers  

ORA-00292: parallel recovery feature not installed

1 Answers  

ORA-22289: cannot perform string operation on an unopened file or LOB

1 Answers   Virtusa,

ORA-26691: operation not supported at non-Oracle system

1 Answers  

ORA-09272: remote os logon is not allowed

1 Answers  




ORA-13762: The string ranking measure is invalid.

1 Answers  

PLS-00483: exception 'string' may appear in at most one exception handler in this block

1 Answers  

RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset

1 Answers  

NZE-29041: The callback is NULL.

1 Answers  

ORA-12822: duplicate option in PARALLEL clause

1 Answers  

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

1 Answers  

ORA-08192: Flashback Table operation is not allowed on fixed tables

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories