Home » RDBMS Server » Server Utilities » DMP FILE IMPORT
DMP FILE IMPORT [message #403068] Wed, 13 May 2009 10:53 Go to next message
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 #403069 is a reply to message #403068] Wed, 13 May 2009 10:54 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What error?

Without that, we're just wasting out time.
Re: DMP FILE IMPORT [message #403082 is a reply to message #403068] Wed, 13 May 2009 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
imp username/password rows=no
Re: DMP FILE IMPORT [message #403083 is a reply to message #403068] Wed, 13 May 2009 11:23 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: DECODE
Next Topic: Importing dmp file - first time
Goto Forum:
  


Current Time: Fri Dec 09 22:56:38 CST 2016

Total time taken to generate the page: 0.06503 seconds