Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export multiple targets using OEM

RE: Export multiple targets using OEM

From: Arun Chakrapani <ArunC_at_1800FLOWERS.com>
Date: Thu, 16 May 2002 21:18:19 -0800
Message-ID: <F001.004632EA.20020516211819@fatcity.com>


It is not possible to have to seperate export jobs running thro oem until and unless u do it thro node jobs where in u can call the export command and tell the export command to use a parfile which u keep it in the os in this parfile u can specify the parameters,
This is the only possibility u can do to have 2 seperate exports running on two different machines.  

-----Original Message-----
Sent: Thursday, May 16, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L

I am using OEM 9.0.1 with job scheduler

I am trying to export full database for multiple targets using the job scheduler.
How do you specify more than one .dmp name and location? I want a .dmp and .log file for each target.
Even though I specified 2 targets, it appears as if only one .dmp file was created
even though 'Job History' shows both exports completed successfully.

Also

How can I specify an environment variable such as %ORACLE_SID% in the path for the .dmp file?

e.g. D:\ORACLE\ADMIN\%ORACLE_SID%\EXP\FILES\EXP.DMP

John Baylis
Database Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada

(604) 697-6476 (Office)
(604) 313-6054 (Cell)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arun Chakrapani
  INET: ArunC_at_1800FLOWERS.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri May 17 2002 - 00:18:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US