| DMP FILE IMPORT [message #403068] |
Wed, 13 May 2009 10:53  |
arjunyadav
Messages: 15
Registered: September 2008
|
Junior Member |
|
|
Hi All,
I have a oracle .dmp file .When I am importing that file,system gives some warning and because of that I am not able to import my
Package body which is very mandatory for me to get .
Is there any way to import only the package specification and body other than that tables from .dmp file.
Because for tables I can manage but in package body important
codes are there I want that package body codes.
Is it possible through IMP command from command prompt.
Thanks & Regards
Arjun
|
|
|
|
|
|
|
|
| Re: DMP FILE IMPORT [message #403083 is a reply to message #403068] |
Wed, 13 May 2009 11:23  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
To add,
what is the version of source and target?
By using imp options
SHOW=y LOG=somefile.log
you can extract the information.
With above options, Import will not be actually done. Instead , the DDL of all objects are dumped.
This somefile.log the will have the DDL for the package you want.
Extract that ddl and recreate the package in target.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
