1  create table mytable
  2  (c1 number,c2 varchar2(100))
  3  partition by range (c1)
  4  (partition p1 values less than (10000),
  5* partition p2 values less than (20000))
scott@9i > /

Table created.
scott@9i > insert into mytable (select rownum c1,dbms_random.string('A',10) C2 FROM DUAL connect by level <=19999);

19999 rows created.

scott@9i > commit;

Commit complete.
 
scott@9i > !exp scott/tiger owner=scott

Export: Release 9.2.0.7.0 - Production on Mon Dec 25 22:30:25 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                        MYTABLE
. . exporting partition                             P1       9999 rows exported
. . exporting partition                             P2      10000 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


scott@9i > drop table mytable;

Table dropped.

scott@9i > !imp scott/tiger fromuser=scott touser=scott

Import: Release 9.2.0.7.0 - Production on Mon Dec 25 22:31:10 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing partition                 "MYTABLE":"P1"       9999 rows imported
. . importing partition                 "MYTABLE":"P2"      10000 rows imported
Import terminated successfully without warnings.

SQL>HOST EXP scott/tiger OWNER=scott FILE=d:\scott.dmp LOG=d:\scott.log