Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: part of the table export (incremental?)

RE: part of the table export (incremental?)

From: Steven Hovington <steven.hovington_at_procession.com>
Date: Fri, 03 Aug 2001 10:57:55 -0700
Message-ID: <F001.0035F897.20010803082202@fatcity.com>

So what should you use
instead?
 
Steven.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of JOE TESTASent: 02   August 2001 17:21To: Multiple recipients of list   ORACLE-LSubject: Re: part of the table export   (incremental?)
  and the incremental/cmulative options in export are only   there for backwards compatibility w/scripts, my understanding is they are not   really supported anymore.
   
  joe
   
>>>

  carmichr_at_hotmail.com 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)"
  <Shrinivas.Tatireddy_at_med.ge.com>>Reply-To:   ORACLE-L_at_fatcity.com>To: Multiple recipients of list ORACLE-L   <ORACLE-L_at_fatcity.com>>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: <A
  href="http://www.orafaq.com">http://www.orafaq.com>-- Received on Fri Aug 03 2001 - 12:57:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US