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: DEMANCHE Luc (Cetelem) <Luc.Demanche_at_cetelem.fr>
Date: Fri, 17 Aug 2001 04:06:36 -0700
Message-ID: <F001.0036E9C2.20010817042338@fatcity.com>

Hi Fawzia,

You can use the QUERY parameter in th export command.

DOC :Oracle8i Utilities
Release 2 (8.1.6)
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 [mailto:Fawzia.Malik_at_open-talk.co.uk] Date: Friday, August 17, 2001 1:07 PM
: 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 Received on Fri Aug 17 2001 - 06:06:36 CDT

Original text of this message

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