I need to be able to refresh the data in the tables belonging to out test
database without destroying, changing, or adding any other type of database
object. The data will come from the production database. I am having a
problem specifically with triggers. I don't want to add, change or delete
On your export you can state if you want triggers are not.
exp file=export_file owner=schema_owner triggers=N
From: Smith, Ron L. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Import data only into existing schema
Date: Wed
ALTER TRIGGER xxx DISABLE;
Hey Jared -- see I can be succinct sometimes!
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 12, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
I need to be able to refresh the data
:RE: Import data only into existing schema
ALTER TRIGGER xxx DISABLE;
Hey Jared -- see I can be succinct sometimes!
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 12, 2003 2:59 PM
To: Multiple recipients of list