Database Administration (MOSC)

MOSC Banner

ORA-01013 during creation of index with timestamp

edited Mar 16, 2011 7:47PM in Database Administration (MOSC) 8 commentsAnswered
 Hello All,

Hope all are doing good!!

I am getting error ORA-01013 during the creation of index with timestamp column.

Please find the column description.

SQL> desc top_fin.BOOKING_CALC_LOG_LINE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SK_BOOKING_ID                             NOT NULL NUMBER(20)
 LOG_LINE_SEQUENCE                         NOT NULL NUMBER(10)
 LOG_LINE_TEXT                             NOT NULL VARCHAR2(4000)
 LOG_LINE_TIMESTAMP                        NOT NULL TIMESTAMP(6)
 SK_FIN_COMPONENT_VERSION_ID                        NUMBER(20)
 BOOKING_TRANS_DATE                        NOT NULL DATE

Thanks in Advance

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