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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
