1、导出exp用法
[oracle@ocmserver]exp help=y

Export: Release 10.2.0.1.0 - Production on Mon Nov 26 22:53:41 2012

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



You can let Export prompt you for parameters by entering the EXP
command followed by your username/password:

         Example: EXP SCOTT/TIGER

Or, you can control how Export runs by entering the EXP command followed
by various arguments. To specify parameters, you use keywords:

         Format:    EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
         Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
                             or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

Keyword        Description (Default)            Keyword            Description (Default)
--------------------------------------------------------------------------
USERID         username/password                    FULL                 export entire file (N)
BUFFER         size of data buffer                OWNER                list of owner usernames
FILE             output files (EXPDAT.DMP)    TABLES             list of table names
COMPRESS     import into one extent (Y) RECORDLENGTH length of IO record
GRANTS         export grants (Y)                    INCTYPE            incremental export type
INDEXES         export indexes (Y)                 RECORD             track incr. export (Y)
DIRECT         direct path (N)                        TRIGGERS         export triggers (Y)
LOG                log file of screen output    STATISTICS     analyze objects (ESTIMATE)
ROWS             export data rows (Y)             PARFILE            parameter filename
CONSISTENT cross-table consistency(N) CONSTRAINTS     export constraints (Y)

OBJECT_CONSISTENT        transaction set to read only during object export (N)
FEEDBACK                         display progress every x rows (0)
FILESIZE                         maximum size of each dump file
FLASHBACK_SCN                SCN used to set session snapshot back to
FLASHBACK_TIME             time used to get the SCN closest to the specified time
QUERY                                select clause used to export a subset of a table
RESUMABLE                        suspend when a space related error is encountered(N)
RESUMABLE_NAME             text string used to identify resumable statement
RESUMABLE_TIMEOUT        wait time for RESUMABLE
TTS_FULL_CHECK             perform full or partial dependency check for TTS
VOLSIZE                            number of bytes to write to each tape volume
TABLESPACES                    list of tablespaces to export
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TEMPLATE                         template name which invokes iAS mode export

Export terminated successfully without warnings.
[oracle@ocmserver]

2，导出数据
不加statistics=none导出
[oracle@ocmserver]exp scott/tiger@ibm file=/opt/oracle/2012.dump log=/opt/oracle/2012.log                                                                    

Export: Release 10.2.0.1.0 - Production on Mon Nov 26 23:01:42 2012

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. 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                                                    BONUS                    0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                                                     DEPT                    4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                                                        EMP                 14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                                             SALGRADE                    5 rows exported
EXP-00091: Exporting questionable statistics.
. 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 with warnings.
[oracle@ocmserver]
加statistics=none统计
[oracle@ocmserver]exp scott/tiger@ibm file=/opt/oracle/2012.dump log=/opt/oracle/2012.log statistics=none feedback=10

Export: Release 10.2.0.1.0 - Production on Mon Nov 26 22:59:16 2012

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. 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                                                    BONUS
                                                                                                                        0 rows exported
. . exporting table                                                     DEPT
                                                                                                                        4 rows exported
. . exporting table                                                        EMP
.
                                                                                                                     14 rows exported
. . exporting table                                             SALGRADE
                                                                                                                        5 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.
[oracle@ocmserver]