Home » SQL & PL/SQL » SQL & PL/SQL » Importing only packages
Importing only packages [message #194931] Tue, 26 September 2006 04:10 Go to next message
Messages: 66
Registered: July 2006
Hi Friends,
I need to know whether there is possibility of importing only packages from an exported dump file into another database.
If yes,kindly tell how to do.

The problem is I want to retrieve the older version of the package now as we dont have the backup of the same.

Re: Importing only packages [message #194932 is a reply to message #194931] Tue, 26 September 2006 04:17 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No direct method ,
Do a full export with rows=s
Do a dummy import like this
imp user/pass show=y file=yourdumpfile log=somelog.sql

now this somelog.sql will have the ddl of all objects.
extract whatever you want.
A much simpler method is to extract DDL from dictionary of source and apply it on target.
use dbms_metadata or any gui tool to extract the ddl.
Please search forum for more examples.
Previous Topic: Bad optimisation of left outer join
Next Topic: Required urgent solution
Goto Forum:

Current Time: Wed Oct 26 00:54:33 CDT 2016

Total time taken to generate the page: 0.11915 seconds