Oracle-L: RE: Import data only into existing schema

From: <Jared.Still_at_radisys.com>
Date: Wed, 12 Mar 2003 14:55:12 -0800
Message-ID: <F001.00568560.20030312145512@fatcity.com>

I can vouch for this being the shortest post Dennis has ever made.

Jared

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Sent by: root_at_fatcity.com
03/12/2003 01:29 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        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.
dwilliams_at_lifetouch.com

-----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 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 any of the triggers in the test environment. If I do an import with the fromuser option it imports the triggers. This also happens with the tables
option of import.

Any ideas?

Ron SMith
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------