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
4384 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-12488: maximum label does not dominate minimum label

1 Answers

NZE-29105: Cannot export PKCS #12 wallet.

1 Answers

TNS-00065: INTCTL: Command cannot be executed remotely

1 Answers

ORA-13345: a compound polygon geometry has fewer than five coordinates

1 Answers

ORA-24787: remote cursors must be closed before a call completes

1 Answers

ORA-13420: the SRID of the geometry parameter was not null

1 Answers

ORA-25951: join index where clause cannot contain OR condition

1 Answers

SQL*Loader-00705: Internal error

1 Answers

ORA-31498: description and remove_description cannot both be specified

1 Answers

SQL*Loader-00462: error inserting LOB into column string, row number, table string

1 Answers

ORA-22914: DROP of nested tables not supported

1 Answers

ORA-07475: slsget: cannot get vm statistics.

1 Answers

For more Oracle Errors Interview Questions Click Here