RE: Exp / Imp Utility Questions

You can use imp to move just the data. Just set ignore=y so that when the object already exists it will move on. You are right about the FK's and disabling them. As for triggers, it really depends on whether or not you want them to fire...

-----Original Message-----
Sent: Friday, December 28, 2001 4:45 AM
To: Multiple recipients of list ORACLE-L

I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old tables / data to the new application on my conversion server. Now I have to load it onto a test server at a different site. I will be using tables= parameter to a select group of tables / data. I have not found the answers to my questions in the documentation.

1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures?
2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc. (they are created by another script). There is no application code attached to this DB. The DB I will be loading to is fully functional - all the PK's, FK's, triggers, functions, et al. Will loading the data from my conversion DB cause problems with the test DB?
3. I know I will have to disable the FK's on the test DB. But, what about the triggers on the applicable tables? Should they be disabled?

        Anything else I need to know before I get rolling on this?

        Thanks,

        Ken Janusz, CPIM
        Database Conversion Lead
        Sufficient Systems, Inc.
        Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).