Skip to Main Content
Forums

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!

ORA-08103 ORA-02063 When inserting from DB Link.

johnnie.billingsOct 30 2017 — edited Oct 30 2017

Hello,

DB: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

We have an issue with an INSERT statement that occurs over a database link.  Here is what the process does:

  • The local table is truncated.
  • An insert is done into the local table from a table across a DB Link.

This runs fine normally, but maybe once a month we will get the following errors:

  • ORA-08103: object no longer exists
  • ORA-02063: preceding line from <DB LINK NAME>

The developer that wrote this code did the classic EXCEPTION WHEN OTHERS error handling so I am missing the full stack trace. The INSERT is straight SQL without any DML Error Logging so I don't have a lot of info other than the SQLERRM.

I haven't been able to reproduce this issue in dev.  Any ideas on how to figure out what the issue is?  I'm going to clean up the exception handling, anything else I can do to get more information?

Thanks,

--Johnnie
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2017
Added on Oct 30 2017
7 comments
1,971 views