RE: IMPORT QUESTION

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
adary_at_mehish.co.il

> -----Original Message-----
> From: Seema Singh [SMTP:oracledbam_at_hotmail.com]
> 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: oracledbam_at_hotmail.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).

-- 
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: adary_at_mehish.co.il

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).