Find Database Object

[raam94]

Hi everyone ,
I'm using PL/SQL Developer for several days (i have always used SQL/Developer).
I have an issue with the function Find Database Object, I need to find (for work) DB Object in all owner, but I must select one owner for to find object.
Is there a way to search an object in all users?

Other thing, i need to export DB Object like Procedure/Function... to other owner (no personal), how can I do? I found only "Export User Object"..

Thank you very much.

 

[jhughes]

I don't know of a way in PL/SQL Developer to do the searching you are asking about, but that is also because I tend to use the various Oracle provided views for such searching. I write queries against all_objects (or dba_objects) to find where an object is (or defined as). Similar I query against user_source / dba_source. Seehttps://docs.oracle.com/en/database...tml#GUID-07AF2D31-B02D-488E-BB45-25CC44EFB6A0 for a listing of all the static data dictionary views that Oracle provides.

When you talk about exporting an object to another owner, are you referring to something as simple as a View Source, copy the DDL, and run it under the new user? You can also use dbms_metadata.get_ddl to export the DDL for objects as well. I'm not sure what your needs are so I'm unsure how to answer your question.