EXPORT HELP

From: Dan White <dwhite_at_icimail.com>
Date: 10 Mar 2001 11:42:53 -0800
Message-ID: <98e03t0ho4@drn.newsguy.com>

Hello all,

I am having the following problem with Oracle's export utility. We are running 8.1.6.2 On a sun box I am using the triggers=N option in my parfile, but when I try to import data I am getting triggers in my dmp file. The my import failes because the triggers are invalid and canot fire.

parfile

DIRECT=y
TABLES=(PI.CMS_FEATURE,PI.PR_PROMOPROJ,PI.CMS_LANGUAGE,PI.PR_PROMOFAMILY,PI.PR_F AMILY,PI.CMS_SCHEDULEDFEATURE,
PI.CMS_FEATUREGENRE)
FILE=/opt/app/oracle/admin/DSTG2/export/dw_prd1.dmp LOG=/opt/app/oracle/admin/DSTG2/logs/dw_prd1.log rows=y
grants=n
constraints=n
indexes=n
compress=n
triggers=n
buffer=655360

Dan White
programmer/analyst Received on Sat Mar 10 2001 - 13:42:53 CST