Re: Export with query clause

Thanks very much - and please accept my apologies. I have now found the example you give in the 8.1.5 utilities manual DOH!

Thanks again

NeilC

Brian McCarthy wrote:
>
> What documentation set are you looking at?
>
> Excuse any line-wrapping below - I need to reset a few netscape
> defaults - from the 8.1.6 Oracle8i Utilties manual:
>
> ------------------
>
> 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\"
>
> [ snip ]
>
> When executing this command, Export builds a SQL SELECT statement
> similar to this:
>
> SELECT * FROM EMP where job='SALESMAN' and sal <1600;
>
> The QUERY is applied to all tables (or table partitions) listed
> in the TABLE parameter. For example, the following statement will
> unload rows in both EMP and BONUS that match the query:
>
> exp scott/tiger tables=emp,bonus query=\"where job=\'SALESMAN\' and
> sal\<1600\"
>
> Again, the SQL statements that Export executes are similar to these:
>
> SELECT * FROM EMP where where job='SALESMAN' and sal <1600;
>
> SELECT * FROM BONUS where where job='SALESMAN' and sal <1600;
>
> If a table is missing the columns specified in the QUERY clause, an
> error message will be produced and
> no rows will be exported for the offending table.
>
> Restrictions
>
> The parameter QUERY cannot be specified for full, user,
> or transportable tablespace mode
> exports.
>
> The parameter QUERY must be applicable to all specified tables.
>
> The parameter QUERY cannot be specified in a direct path export
> (DIRECT=Y)
>
> The parameter QUERY cannot be specified for tables with inner
> nested tables.
>
> You will not be able to determine from the contents of the
> export file whether the data is the result
> of a QUERY export.
>
> -----------------------------------------
>
> Brian McCarthy - Oracle
>
> NeilC wrote:
> >
> > Hi,
> >
> > could someone give a quick example of using the QUERY clause of export.
> > I have looked at the documentation but there is no example.
> > At what level can it be used at FULL, USER, TABLE ??
> >
> > any help and examples appreciated
> >
Received on Fri Jan 14 2000 - 06:57:42 CST