Home » Other » General » Getting All Objects Scripts in a Package (NA)
Getting All Objects Scripts in a Package [message #379460] Tue, 06 January 2009 10:47 Go to next message
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
Re: Getting All Objects Scripts in a Package [message #379463 is a reply to message #379460] Tue, 06 January 2009 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
Re: Getting All Objects Scripts in a Package [message #379639 is a reply to message #379463] Wed, 07 January 2009 07:30 Go to previous message
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:
  


Current Time: Sun Nov 03 06:44:03 CST 2024