Hello Seema You will have to use incremental export AND incremental import. Incremental export will export only the tables that were updated. Incremental import will DROP these tables and then will create them and import data into them.
The difference between regular import and incremental import is that regular import assume that the tables does not exist and gives errors if a table exist (of course you can ignore them). Incremental import assumes that the tables already exist in the database and will drop them and create them again. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 28, 2002 6:03 PM > To: Multiple recipients of list ORACLE-L > Subject: IMPORT QUESTION > > Hi > I want to switch database from one server to another server.I want do data > > migration thru export/import.How can I run incremental import.Is it > necessary to have incremental export? > I want to migrate data thru export/import.What ever the tables updated > during import on old server I want to do reimport on new serevr.There is > one > parameter INCTYPE is available in export/import both.Is it necessary to > have > incremental export to take incremental import? > Please suggest. > Thx > -seema > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp.; > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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).
