OraFAQ Forum: General » Getting All Objects Scripts in a Package

Home » Other » General » Getting All Objects Scripts in a Package (NA)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting All Objects Scripts in a Package [message #379460]

Tue, 06 January 2009 10:47

shankhan
Messages: 28
Registered: September 2008
Location: Pakistan

Junior Member

Dear All,
I am PL/SQL Developer but have to perform some task that comes under database administration domain.

I have a package which references many tables, sequences etc.
I want to get the scripts of all those tables and sequences that are used in the package.

Thanks,
M. Usman

Report message to a moderator

Re: Getting All Objects Scripts in a Package [message #379463 is a reply to message #379460]

Tue, 06 January 2009 10:53

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Theorically you should have them in your code repository and application specifications as table and all other object definitions are part of the code.

Regards
Michel

Report message to a moderator

Re: Getting All Objects Scripts in a Package [message #379639 is a reply to message #379463]

Wed, 07 January 2009 07:30

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Have a play with dba_dependencies

SELECT referenced_name, referenced_type
  FROM dba_dependencies
 WHERE TYPE = 'PACKAGE BODY'
 AND NAME = 'PKG_NAME' 
 AND owner = 'OWNER';

[Updated on: Wed, 07 January 2009 07:30]

Report message to a moderator

Previous Topic:	license prices
Next Topic:	ORA-03113: end-of-file on communication channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 10 19:02:34 CDT 2023