system owned object

If dba is unsure in which script a sys or system-owned object is created and dba know that is in a script from a specific directory...May I know which  UNIX command from that directory structure can dba run to...
Who is Participating?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you cannot know from the unix to find the file which contains the creation script for a given object.
though you could use "find" to search for the text string, still it's not sure you will get the correct file, as
1) the object could be used in other (depending) scripts
2) there could be different versions (for different upgrade scenarios) of the same object.

best is you check the documentation about which file should be run to create a given object
slightwv (䄆 Netminder) Commented:
I agree with everything above.  You should not run scripts just because you 'think' it is the correct one.

Are you looking for a specific object?  We might be able to provide the correct script.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.