RE: Exp / Imp Utility Questions

1. You cannot have read the docs to well not to know the answer to Q1 Hint  - look at the ignore parameter to imp
2. It all depends if the triggers have been run once to change the data that is now in the conversion db. You may have a trigger that adds 1 to a field. If the data has been populated into a table with the trigger enabled it will have  value of field + 1. If you then import the data into your test db with a trigger enabled it will action the trigger and the field will then have the value of field +1 +1. Remember import is only a fancy way of typing insert into for each row of data

3)  As you say, it is a test database, experiment with a couple of tables and find out the answers for yourself. That is the best way of learning

John

-----Original Message-----
From: Ken Janusz [mailto:ken.janusz_at_sufsys.com] Sent: 28 December 2001 12:45
To: Multiple recipients of list ORACLE-L Subject: Exp / Imp Utility Questions

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).




=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================