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



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

NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string

1 Answers  


SQL*Loader-00531: OCI return status: still executing

1 Answers  


ORA-01621: cannot rename member of current log if database is open

1 Answers  


ORA-04070: invalid trigger name

1 Answers  


PLS-00124: name of exception expected for first arg in exception_init pragma

1 Answers  


ORA-25501: ALTER SYSTEM QUIESCE RESTRICTED command failed

1 Answers  


ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.

1 Answers  


ORA-01660: tablespace 'string' is already permanent

1 Answers  


ORA-01139: RESETLOGS option only valid after an incomplete database recovery

1 Answers  


RMAN-20011: target database incarnation is not current in recovery catalog

1 Answers  


ORA-01037: maximum cursor memory exceeded

1 Answers  


ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers  


Categories