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
4228 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

SQL-02120: First and second arguments to SQLRCN both null

1 Answers

EXP-00003: no storage definition found for segment(number, number)

2 Answers

ORA-16076: unknown standby database destination

1 Answers

ORA-26091: requested direct path operation not supported

1 Answers

ORA-10635: Invalid segment or tablespace type

1 Answers

IMG-00582: output format does not support the specified interleave

1 Answers

ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers

ORA-13437: GeoRaster metadata blocking error

1 Answers

ORA-02260: table can have only one primary key

1 Answers

ORA-39305: specified schema "string" does not exist

1 Answers

ORA-33030: (XSAGDNGL14) In AGGMAP workspace object, you can have either a single independent PROTECT statement or PROTECT statements in your RELATION statements.

1 Answers

ORA-01192: must have at least one enabled thread

1 Answers

For more Oracle Errors Interview Questions Click Here