Re: Exp Problem

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 19 Oct 2001 06:24:52 +1000
Message-ID: <3bcf3868@news.iprimus.com.au>

First, be advised that incremental exports only work at the *table* level. In other words, if a million row table has 1 row updated, the entire million rows goes into the export dump file, even if its an incremental export you're doing. So you're simply never going to get a dump file *only* containing the 2 extra rows you've asked for.

Second, you export command line is requesting a full database export, even though it's asking for an incremental full database export. If you're only interested in Mr. ABC's tables, then you should tack on the OWNER=ABC parameter.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"adil" <aadil_at_loveable.com> wrote in message
news:2f4ab398.0110172233.369710c_at_posting.google.com...


> Hi all,

>

> i created 2 tables and inserted 5 rows in each in user abc

> and took dump using this command

>

> exp userid=abc/abc_at_xyz file=d:\abc\abc.dmp

>

> latter i inserted 2 more rows in those 2 tables in abc user

> how do i take incremental dump

> is this command correct for incremental dump

>

> exp userid=abc/abc_at_xyz file=d:\abc\abc.dmp inctype=incremental

>

> i tried the above and its taking the dmp of all the users of zyx instance

> pls correct me where i am wrong

>

> thanks in advance

> Adil

Received on Thu Oct 18 2001 - 15:24:52 CDT