Login  Register

Re: GSS Errorred out

Posted by ErmanArslansOracleBlog on Mar 02, 2020; 7:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/GSS-Errorred-out-tp8092p8104.html

If you have audit configured, then yes you can easily find it.
If not, still you have other opportunities, Log miner is one of them. Using Log miner you can find the SQL used for the related DDL. This might give you a clue.

You can also check the DBA_SOURCe for finding the PLSQL that is programmed to create that table.. You can query dba_source with a that table name used as a keyword and try to find the PLSQL program responsible for creating it. Once you find it, you can go further and build the relationship with the functional process executing it.

Normally, this should not be the case. It is a Custom table and the answer should already be provided by your developers. Make them check their documentation for these customizations and get back to you.