Re: Export limited number of rows

Yes it is made possible with Oracle 8i onwards by including the Query Clause in the Export. Check the exact syntax based on your OS as there is small difference on UNIX and NT in the Query clause

Create the Par file for the export
<<exp.par>>
userid=user/password
file=indy.dmp
log=indy.log
tables=employee
query="where rownum < 100"

now run the exp like

exp parfile=exp.par

Good Luck
Indy

"Ernst Breivik" <Ernst-Hugo.Breivik_at_telenor.com> wrote in message news:<7Aaw9.1873$Hb.98073_at_news2.ulv.nextra.no>...
> Hi.
>
> Is it possible to do an export of a table and limit the number of rows to
> say 100?
>
> E Breivik
Received on Thu Oct 31 2002 - 21:44:09 CET