SQL Language (MOSC)

MOSC Banner

ORA-30082: datetime/interval column to be modified

edited Feb 19, 2016 4:08AM in SQL Language (MOSC) 3 commentsAnswered

Is there any way to resolve the below ORA-30082 error.

SQL> select * from t2_date;

EFF_DT1
---------------------------------------------------------------------------
JOIN_DT
---------------------------------------------------------------------------
03-FEB-16 09.30.05.422 PM
03-FEB-16 09.30.05.421689 PM


SQL> alter table t2_date modify Join_dt timestamp(3);
alter table t2_date modify Join_dt timestamp(3)
                           *
ERROR at line 1:
ORA-30082: datetime/interval column to be modified must be empty to decrease
fractional second or leading field precision
.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center