Re: Datapumop question
Date: Wed, 14 Oct 2009 05:00:24 -0700 (PDT)
you can use impdp with SQLFILE parameter to verify what was exported.
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 ...
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).
From: John Dunn <JDunn_at_sefas.com>
To: Michael Elkin <melkin4u_at_gmail.com> Cc: oracle-l_at_freelists.org
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
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_at_gmail.com] Sent: 14 October 2009 10:24
Subject: Re: Datapumop question
Can you specify exactly what do you want to do ?
On Wed, Oct 14, 2009 at 10:40 AM, John Dunn <JDunn_at_sefas.com> 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?
-- Best Regards Michael Elkin -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 14 2009 - 07:00:24 CDT