From Fawzia.Malik@open-talk.co.uk Fri, 17 Aug 2001 05:03:26 -0700
From: "Malik, Fawzia" <Fawzia.Malik@open-talk.co.uk>
Date: Fri, 17 Aug 2001 05:03:26 -0700
Subject: RE: Export
Message-ID: <F001.0036EA76.20010817050054@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Export



thanks 
all I found it in the online docs, but do appreciate all the 
responses...

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: DEMANCHE Luc (Cetelem) 
  [mailto:Luc.Demanche@cetelem.fr]Sent: 17 August 2001 
  13:24To: Multiple recipients of list ORACLE-LSubject: 
  RE: Export
  Hi Fawzia, 
  You can use the QUERY parameter in th export command. 
  
  DOC :Oracle8i Utilities <FONT 
  size=2>     Release 2 (8.1.6) <FONT 
  size=2>     A76955-01 
  QUERY Default: none 
  This parameter allows you to select a subset of rows from a 
  set of tables when doing a table mode export. The value of the query parameter 
  is a string that contains a WHERE clause for a SQL SELECT statement that will 
  be applied to all tables (or table partitions) listed in the TABLE parameter. 
  
  For example, if user SCOTT wants to export only those 
  employees whose job title is SALESMAN and whose salary is greater than 1600, 
  he could do the following (note that this example is UNIX-based): 
  exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and 
  sal\<1600\" 
  ... ... 
  Luc 
  -----Message d'origine----- De: Malik, 
  Fawzia [<A 
  href="mailto:Fawzia.Malik@open-talk.co.uk">mailto:Fawzia.Malik@open-talk.co.uk] 
  Date: Friday, August 17, 2001 1:07 PM <FONT 
  size=2>À: Multiple recipients of list ORACLE-L Objet: 
  Export 
  Hi 
  Can you please tell me if there is a way of exporting select 
  rows from a given table in 8.1.6.2??? 
  Thanks in advance 
  Rgds 
  Fawzia 

This message is confidential and is intended for the addressee only; unless clearly 
stated that this disclaimer should not apply, this e-mail is not intended to create 
legally
 binding commitments on behalf of any company in the British Interactive Broadcasting 
Holding Limited group, nor do its contents reflect the corporate views or policies of 
any 
such company. Any unauthorised disclosure, use or dissemination, either whole or 
partial, is prohibited. If you are not the intended recipient of the message, please 
notify 
the sender immediately.