Re: Exp / Imp Utility Questions

Ken Janusz wrote:
>
> 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?

   If you do not specify IGNORE=Y, if the table already exists (which I presume is the case since you only are interested by the data) the default behaviour is to skip the data. So, the answer is yes if you specify IGNORE=Y.

> 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?

    No.
> 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?

   Yes, because imp fires them if they preexist.  

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

   You will probably get lots of error messages in the process ... You may find this useful :

   http://www.oriole.com/frameindexFS.html

and check for the 'All you ever wanted to know about exp and imp' paper.

HTH, Stephane Faroult
Oriole Ltd

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).