Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import DATA ONLY without firering triggers

user22208Nov 9 2010 — edited Nov 11 2010

Hi , I'm on 10.2.0.4 on windows 2008. I did an Export (EXPDP) with data on ly of a USER , I want to import (IMPDP) the data back to this user with the TRUNCATE option.

Everything seems ok before I saw that the trigger on my tables are fired because import does INSERTS..

There are my parameters :

DUMPFILE="DESTRUCTION_DATA.dmp"
LOGFILE="imp_DESTRUCTION_DATA.log"
DIRECTORY=DATA_PUMP_DIR
CONTENT=DATA_ONLY
TABLE_EXISTS_ACTION=TRUNCATE
JOB_NAME='xxxxxx'

What is the best way to EXPORT and IMPORT only the data of a user without trigerring everything.

What I want to do is to refresh my test database with productiomn data. I don't want to DROP the user and recreate all his objects.

Edited by: Jpmill on 2010-11-09 12:01

This post has been answered by Nelson Calero on Nov 9 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2010

Added on Nov 9 2010

#database-key-features, #export-import-sql-loader-external-tables

10 comments

10,564 views