Import data only into existing schema

2003-03-12 Thread Smith, Ron L.
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

Re: Import data only into existing schema

2003-03-12 Thread Charles Hart
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

RE: Import data only into existing schema

2003-03-12 Thread DENNIS WILLIAMS
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

2003-03-12 Thread Jared . Still
: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