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

Home -> Community -> Usenet -> c.d.o.server -> Preventing jobs from being imported

Preventing jobs from being imported

From: <hboswel1_at_bellsouth.net>
Date: Mon, 09 Aug 2004 10:34:02 -0500
Message-ID: <h16fh0djafi0oian22e6bu9sskpnvicvgq@4ax.com>


I have a nightly export/import job that runs, to place some data on a database server that sits outside our firewall. The export parfile has these parameters:

COMPRESS=Y
GRANTS=Y
INDEXES=Y
ROWS=Y
CONSTRAINTS=Y
TRIGGERS=Y The import parfile has these commands:

INDEXES=Y
GRANTS=Y
CONSTRAINTS=Y
ROWS=Y
IGNORE=Y
ANALYZE=N The schema being exported/imported has some jobs associated with it, that I don't want exported or imported, but that's happening. How do I prevent this? I haven't found mention on jobs in the exp/imp documentation, and a Metalink search didn't turn anything up.

Thanks,
Harry Boswell Received on Mon Aug 09 2004 - 10:34:02 CDT

Original text of this message

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