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: Export

RE: Export

From: Malik, Fawzia <Fawzia.Malik_at_open-talk.co.uk>
Date: Fri, 17 Aug 2001 05:03:26 -0700
Message-ID: <F001.0036EA76.20010817050054@fatcity.com>

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_at_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_at_open-talk.co.uk">mailto:Fawzia.Malik_at_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. Received on Fri Aug 17 2001 - 07:03:26 CDT

Original text of this message

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