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

IMG-00823: boundary queue pop failed

1 Answers

TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA

1 Answers

LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers

LSX-00262: attribute "~1S" cannot have complex type "~2S"

1 Answers

RMAN-06410: cannot use command when channels are allocated

1 Answers

ORA-01517: log member: 'string'

1 Answers

TNS-12690: Server Authentication failed, login cancelled

1 Answers

ORA-31658: specifying a schema name requires a table name

1 Answers

ORA-24339: cannot set server group name after connecting to server

1 Answers

ORA-23485: Column group "string" must consist of a single numeric column only

1 Answers

ORA-16807: unable to set protection mode to the database

1 Answers

QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode

1 Answers

For more Oracle Errors Interview Questions Click Here