I recall this was possible in the earlier versions.

Ramesh L


>From: "Mitchell Baldwin" <Mitchell.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: Export parameters
>Date: Fri, 30 Jan 2004 15:27:15 -0000
>
>Yes, the exp parameter is QUERY
>
>do 'exp help=y' this will show you all the parameters
>
>Check the syntax as it's a bit twitchy !...
>
>
>-----Original Message-----
>From: Gareth Spicer [mailto:[Email Address Removed] 30 January 2004 12:17
>To: LazyDBA.com Discussion
>Subject: Export parameters
>
>
>Is it possible to export a table with set criteria on the data in oracle
>9i?
>
>What I am trying to do is export a table where insert_date = '200401', is
>this possible or can I only export the whole table?
>
>Many thanks in advance
>
>Gareth
>###########################################
>
>This message has been scanned by F-Secure Anti-Virus for Microsoft
>Exchange.
>For more information, connect to http://www.F-Secure.com/
>
>
>--------
>Get today's cartoon: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>

_________________________________________________________________
Contact brides & grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag
Only on www.shaadi.com. Register now!

Oracle LazyDBA home page