Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE - error ORA-08103: Object no longer exists

User_ZXBTCDec 30 2020

I have below code :
TRUNCATE TABLE T1;
INSERT INTO T1
SELECT * FROM TEMP1
UNION
SELECT * FROM TEMP2
UNION
SELECT * FROM TEMP3;

INSERT statement is throwing error ORA-08103: Object no longer exists.

Please help to find out the root cause of this error.

Thank you in advance.

Comments
Post Details
Added on Dec 30 2020
6 comments
1,023 views