Re: Datapumop question
- From: adrian angelov <adrian_angelov@xxxxxxxxx>
- To: JDunn@xxxxxxxxx, Michael Elkin <melkin4u@xxxxxxxxx>
- Date: Wed, 14 Oct 2009 05:00:24 -0700 (PDT)
Hi John,
you can use impdp with SQLFILE parameter to verify what was exported.
An example:
expdp adri/adri directory=DATA_PUMP_DIR dumpfile=adri.dpdump schemas=adri
impdp adri/adri dumpfile=data_pump_dir:adri.dpdump
sqlfile=data_pump_dir:adri.sqlfile
adri.sqlfile contains the needed code for recreation of JAVA objects too ...
See the docs:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm
Note that when you specify INCLUDE during the export you only export what
you've specified and all dependent objects(described in the documentation too).
Adrian Angelov
________________________________
From: John Dunn <JDunn@xxxxxxxxx>
To: Michael Elkin <melkin4u@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Wed, October 14, 2009 12:45:36 PM
Subject: RE: Datapumop question
What I am trying to do is dump all code from my
schema(pl/sql and java loaded via loadjava).
I was trying to get a list of what has been
dumped.
I am not sure whether the java code loaded via loadjava
has been dumped.
Here are my datapump parameters. I am not sure if they
are corerect for what I am trying to do..i.e dump all code.
expdp johnschema/john schemas=johnschema directory=admin_dir dumpfile=dp.dmp
logfile=dp.log include=PROCEDURE include=PACKAGE
include=PACKAGE_BODY include=FUNCTION include=JAVA_CLASS
________________________________
From: Michael Elkin [mailto:melkin4u@xxxxxxxxx]
Sent: 14 October 2009 10:24
To: John
Dunn
Subject: Re: Datapumop question
Can you specify exactly what do you want to do
?
Michael
On Wed, Oct 14, 2009 at 10:40 AM, John Dunn <JDunn@xxxxxxxxx> wrote:
What option do I need to specify for
> DataPump to get it to list the names of the obejcts exported in
> the log file?
>
>John Dunn
--
Best Regards
Michael Elkin
Other related posts:
