how can user_DEPENDENCIES read from the procedure

Posted by Moudiz on Stack Overflow See other posts from Stack Overflow or by Moudiz
Published on 2013-10-31T15:36:51Z Indexed on 2013/10/31 15:53 UTC
Read the original article Hit count: 240

Filed under:

If I run this query :

SELECT DISTINCT U.REFERENCED_NAME, U.REFERENCED_TYPE
FROM USER_DEPENDENCIES U
where U.name IN('P_CREATE_T')

It will give me :

  U.REFERENCED_NAME |  U.REFERENCED_TYPE
  random_name_table | table

If I drop this table random_name_table :

drop table random_name_table

and I run the dependecie query It will give me this:

        U.REFERENCED_NAME        |  U.REFERENCED_TYPE
  BIN$6WfJh8MWWGngQ3ATqMDOpQ==$0 | table

I know the result is related to recycle bin, But what I am asking is there a way that shows the table even if its droped ? I mean shouldnt the depency query read from the procedure and not from the database ? If not is there a query that reads from the procedure and not from database ?


Edit
ok I will make it clear :
my question USER_DEPENDENCIES read from the procedure or the database ? My second question does the recycle bin always shows ? I mean is there times where the result of the recylebin disapear ?

© Stack Overflow or respective owner

Related posts about Oracle