>>>
[EMAIL PROTECTED] 08/02/01 10:30AM >>>
if you are running 8i,
you can use a where clause on the export.
incremental export does not
export only the changed rows but will export the
entire table if even as
little as one byte in one row has changed.
>From: "Tatireddy,
Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]>
>Reply-To:
[EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>Subject: part of the table export
(incremental?)
>Date: Thu, 02 Aug 2001 02:05:26 -0800
>
>Hi
dba's
>
>can anybody tell me how to do export part of the
table..
>
>i.e. incremental data.
>
>when i exported
at 10 am it has 1000 rows ( i did full exp)
>
>100 rows newly
added in the 2 hrs
>
>when i do exported at 12 am ( incremental)
it exporting all the
>rows(1100) of the table
>
>but i need
only the rows, that are newly inserted.
>
>is there any way to do
such export?
>
>thnx in
adv
>
>srinivas
>--
>Please see the official ORACLE-L
FAQ:
http://www.orafaq.com>--
