Oracle-L: RE: Help with IMPort

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 06 Jan 2003 01:23:42 -0800
Message-ID: <F001.0052755D.20030106012342@fatcity.com>

Hi Raja Kumar,

If you don't know what are the differences use the parameters touser and fromuser

During importation
Oracle will recreate those tables

I think if you not use the ignore = y you will get error message since Oracle cannot insert due to different table structure Just guessing

If you are not require to know those table structure differences then you can drop the tables first.

Other Important Note: Make sure your dump file exported with parameter compress = n

Sinardy

-----Original Message-----
Sent: 06 January 2003 16:34
To: Multiple recipients of list ORACLE-L

I have 2 8i database out of which one is production and the other is for development and testing.

How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones.

Thanks
--

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

Author:
INET: Raja.Kumar_at_akerkvaerner.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: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

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