Home » SQL & PL/SQL » SQL & PL/SQL » Find and trace custom view/procedure...
Find and trace custom view/procedure... [message #585366] Fri, 24 May 2013 06:23 Go to next message
gatetec
Messages: 38
Registered: December 2012
Member
I know that this query had been executed again the db, but the person is no longer here. Last run was about 3~4 months ago.
SELECT   Subject_ID,
         TO_CHAR (completed_date, 'mm/dd/yyyy'), status
         FROM ADMINDBG_USER.adbt_master
         ...


[ADMINDBG_USER.adbt_master] is not a part of [dba_tables]. [ADMINDBG_USER.adbt_master] must be a view/procedure/a sort.
I have no luck to find what view/procedure/syntax is populating the data onto [ADMINDBG_USER.adbt_master].

Please advise how to find the info.

Appreciate your help.

[Updated on: Fri, 24 May 2013 06:24]

Report message to a moderator

Re: Find and trace custom view/procedure... [message #585367 is a reply to message #585366] Fri, 24 May 2013 06:39 Go to previous messageGo to next message
cookiemonster
Messages: 10913
Registered: September 2008
Location: Rainy Manchester
Senior Member
have a look in dba_objects
Re: Find and trace custom view/procedure... [message #585369 is a reply to message #585367] Fri, 24 May 2013 06:47 Go to previous messageGo to next message
gatetec
Messages: 38
Registered: December 2012
Member
It is not there. I strongly feel that [ADMINDBG_USER.adbt_master] is from View.
How do you find it? I might not have searched it correctly.
Re: Find and trace custom view/procedure... [message #585370 is a reply to message #585369] Fri, 24 May 2013 06:50 Go to previous messageGo to next message
cookiemonster
Messages: 10913
Registered: September 2008
Location: Rainy Manchester
Senior Member
Anything in the from cause must be a db object (be it a table, view, object, pipelined function etc), so must appear in dba_objects.
If it's not there then it's been dropped.
Re: Find and trace custom view/procedure... [message #585373 is a reply to message #585370] Fri, 24 May 2013 07:37 Go to previous messageGo to next message
gatetec
Messages: 38
Registered: December 2012
Member
I was hoping to get the syntax... In this case, is there no way to get the syntax, by looking up the query history, else??
Re: Find and trace custom view/procedure... [message #585391 is a reply to message #585373] Fri, 24 May 2013 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 58903
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the result of
select owner, object_name, object_type 
from dba_objects
where upper(owner) = 'ADMINDBG_USER'
  and lower(object_name)= lower('adbt_master')
/

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Find and trace custom view/procedure... [message #585394 is a reply to message #585373] Fri, 24 May 2013 10:37 Go to previous messageGo to next message
gatetec
Messages: 38
Registered: December 2012
Member
I got no result returned.
Re: Find and trace custom view/procedure... [message #585399 is a reply to message #585394] Fri, 24 May 2013 10:45 Go to previous message
Michel Cadot
Messages: 58903
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have no such object to query and have no more to be concerned about the query.

Regards
Michel
Previous Topic: How to extract full text from clob where I have a distict select
Next Topic: Scheduling same job with different timing.
Goto Forum:
  


Current Time: Wed Aug 27 09:54:27 CDT 2014

Total time taken to generate the page: 0.10529 seconds