[oracle@localhost script]$ exp
Export: Release 8.1.7.4.0 - Production on Fri Feb 6 15:01:07 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: cams --此处输入启动导出的用户
Password: --此处输入相应的密码
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 -Production
JServer Release 8.1.7.4.0 - Production
Enter array fetch buffer size: 4096 >--此处需要输入buffer 值交互式导出时大多数参数都有缺省值,如果选用缺省值,直接回车即可.
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > --此处输入导出模式,全库导出,用户导出还是表导出,缺省为用户导出.
Export grants (yes/no): yes > --是否导出授权通常选择yes
Export table data (yes/no): yes > --是否导出表中数据如果选择no则只导出表的结构通常选择yes
Compress extents (yes/no): yes > --选择yes
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR
character set
About to export specified users ...
User to be exported: (RETURN to quit) > cams --此处输入需要导出的用户,如果需要导出多个用户的数据,exp 会一直提示用户,直至用户输入了..
User to be exported: (RETURN to quit) > .. --此处输入".."
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CAMS
. exporting object type definitions for user CAMS
About to export CAMS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CAMS's tables via Conventional Path ...