Oracle Database Discussions

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!

Finding what is running in the DB at a certain time

HiltonMeyerFeb 9 2017 — edited Mar 7 2017

Hi there,

I'm looking for the best method to be able to debug an issue. On one day during the week a program is ending with an error:

Cause: FDPSTP failed due to ORA-08103: object no longer exists

ORA-06512: at "APPS.MLM_SLIM4_INTERFACES_PKG", line 3853

ORA-06512: at "APPS.MLM_SLIM4_INTERFACES_PKG", line 5021

ORA-06512: at line 1

My the thing is that the table exists when checked in the morning. So I'm trying ti verify whether there is anything doing something before the time to invalidate or somehow drop the object.

This post has been answered by MsJ on Feb 15 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2017

Added on Feb 9 2017

#general-database-discussions

18 comments

1,711 views