Oracle Database Discussions

hi

I have two tables LIB_BOOK_ISSUE and LIB_BOOK_ISSUE5. Both tables have same fields (Primary Key: ISSUE_DATE and AC_NO).

I am using 'INSERT INTO LIB_BOOK_ISSUE SELECT * FROM LIB_BOOK_ISSUE5' to move data from LIB_BOOK_ISSUE5 to LIB_BOOK_ISSUE. But there is an error 'ORA-00001: unique constraint violated'.

ISSUE_DATE column is saving both Date and Time. I think, when I use the above INSERT statement then just 'Date' is transferred and 'Time' data is not transferred. Therefore there is an error of unique key violation.

Plz write me to resolve this problem.

thanks