Re: Datapumop question

From: adrian angelov <adrian_angelov_at_yahoo.com>
Date: Wed, 14 Oct 2009 05:00:24 -0700 (PDT)
Message-ID: <307070.44745.qm_at_web52512.mail.re2.yahoo.com>

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_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 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_at_gmail.com] 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_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?
>
>John Dunn

-- 
Best Regards
Michael Elkin



      
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 14 2009 - 07:00:24 CDT