SQL> create table test as select level num from dual connect by level <= 1000000;

Table created.

SQL> select sysdate from dual;
SYSDATE
-------------------
03/06/2008 15:20:52

1 row selected.

SQL> host exp michel/michel file=t.dmp buffer=10000000 tables=test

Export: Release 10.2.0.4.0 - Production on Tue Jun 3 15:21:18 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                           TEST    1000000 rows exported
Export terminated successfully without warnings.

SQL> select sysdate from dual;
SYSDATE
-------------------
03/06/2008 15:21:44

1 row selected.