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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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).
