设置这个参数:FILESIZE 各转储文件的最大尺寸exp jxmis/jxmis@ora8i owner = jxmis FILE = e:\2.dmp FILESIZE = 5MEXP语法
C:\>exp -?
template IAS Template to be used
silent silent: display banner information, default is N
userid user/password to connect to oracle: no default
recordlength record length of file: optional, default is system depen
dent
buffer array fetch buffer size: default is EXUAFCH (4096)
file export file names: format is (file1, file2...) default is EXPDAT
.DMP
full export entire database: default is N
grants export grants option: default is Y
rows export rows option: default is Y
compress compact extents option: default is Y
trace trace option: enable sql_trace and timed_stat, default is N
owner users to export: format is '(user1,user2,..,userN)'
tables tables to export: format is '(table1, table2,...,tableN)'
parfile parameter file: name of file that contains parameter specificati
ons
indexes export indexes option: default is Y
inctype incremental export option: (incremental, cumulative or complete)record option to record incremental/cumulative export: default is Y
constraints export table constraints option: default is Y
consistent provide read-consistency for the entire export: default
is N
help help: display descriptions on export parameters, default is N
log log export messages to specified file
statistics analyze option: (estimate, cumulative, none)
feedback feedback in rows default is EXUFDB
direct direct path option: default is N
point_in_time_recover point-in-time recover option: default is N
tablespaces tablespaces to transport or recover: format is '(ts1, ts
2,...,tsN)'
query query used to select a subset of rows for a table
filesize file size: the size of export dump files
transport_tablespace transportable tablespace option: default is N
triggers export triggers option: default is Y
impparfile file to create as paramfile for IMP for transportable ta
blespaces
file_format format of export file names
通过输入 EXP 命令和用户名/口令,您可以
在用户 / 口令之后的命令:实例: EXP SCOTT/TIGER或者,您也可以通过输入跟有各种参数的 EXP 命令来控制“导出”
的运行方式。要指定参数,您可以使用关键字:格式: EXP KEYWORD=value 或 KEYWORD=(value1,value2,...,valueN)
实例: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
或 TABLES=(T1: P1,T1: P2),如果 T1 是分区表USERID 必须是命令行中的第一个参数。关键字 说明(默认) 关键字 说明(默认)
--------------------------------------------------------------------------
USERID 用户名/口令 FULL 导出整个文件 (N)
BUFFER 数据缓冲区的大小 OWNER 所有者用户名列表
FILE 输出文件 (EXPDAT.DMP) TABLES 表名列表
COMPRESS 导入一个范围 (Y) RECORDLENGTH IO 记录的长度
GRANTS 导出权限 (Y) INCTYPE 增量导出类型
INDEXES 导出索引 (Y) RECORD 跟踪增量导出 (Y)
ROWS 导出数据行 (Y) PARFILE 参数文件名
CONSTRAINTS 导出限制 (Y) CONSISTENT 交叉表一致性
LOG 屏幕输出的日志文件 STATISTICS 分析对象 (ESTIMATE)
DIRECT 直接路径 (N) TRIGGERS 导出触发器 (Y)
FEEDBACK 显示每 x 行 (0) 的进度
FILESIZE 各转储文件的最大尺寸
QUERY 选定导出表子集的子句下列关键字仅用于可传输的表空间
TRANSPORT_TABLESPACE 导出可传输的表空间元数据 (N)
TABLESPACES 将传输的表空间列表
C:\>exp -?
template IAS Template to be used
silent silent: display banner information, default is N
userid user/password to connect to oracle: no default
recordlength record length of file: optional, default is system depen
dent
buffer array fetch buffer size: default is EXUAFCH (4096)
file export file names: format is (file1, file2...) default is EXPDAT
.DMP
full export entire database: default is N
grants export grants option: default is Y
rows export rows option: default is Y
compress compact extents option: default is Y
trace trace option: enable sql_trace and timed_stat, default is N
owner users to export: format is '(user1,user2,..,userN)'
tables tables to export: format is '(table1, table2,...,tableN)'
parfile parameter file: name of file that contains parameter specificati
ons
indexes export indexes option: default is Y
inctype incremental export option: (incremental, cumulative or complete)record option to record incremental/cumulative export: default is Y
constraints export table constraints option: default is Y
consistent provide read-consistency for the entire export: default
is N
help help: display descriptions on export parameters, default is N
log log export messages to specified file
statistics analyze option: (estimate, cumulative, none)
feedback feedback in rows default is EXUFDB
direct direct path option: default is N
point_in_time_recover point-in-time recover option: default is N
tablespaces tablespaces to transport or recover: format is '(ts1, ts
2,...,tsN)'
query query used to select a subset of rows for a table
filesize file size: the size of export dump files
transport_tablespace transportable tablespace option: default is N
triggers export triggers option: default is Y
impparfile file to create as paramfile for IMP for transportable ta
blespaces
file_format format of export file names
通过输入 EXP 命令和用户名/口令,您可以
在用户 / 口令之后的命令:实例: EXP SCOTT/TIGER或者,您也可以通过输入跟有各种参数的 EXP 命令来控制“导出”
的运行方式。要指定参数,您可以使用关键字:格式: EXP KEYWORD=value 或 KEYWORD=(value1,value2,...,valueN)
实例: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
或 TABLES=(T1: P1,T1: P2),如果 T1 是分区表USERID 必须是命令行中的第一个参数。关键字 说明(默认) 关键字 说明(默认)
--------------------------------------------------------------------------
USERID 用户名/口令 FULL 导出整个文件 (N)
BUFFER 数据缓冲区的大小 OWNER 所有者用户名列表
FILE 输出文件 (EXPDAT.DMP) TABLES 表名列表
COMPRESS 导入一个范围 (Y) RECORDLENGTH IO 记录的长度
GRANTS 导出权限 (Y) INCTYPE 增量导出类型
INDEXES 导出索引 (Y) RECORD 跟踪增量导出 (Y)
ROWS 导出数据行 (Y) PARFILE 参数文件名
CONSTRAINTS 导出限制 (Y) CONSISTENT 交叉表一致性
LOG 屏幕输出的日志文件 STATISTICS 分析对象 (ESTIMATE)
DIRECT 直接路径 (N) TRIGGERS 导出触发器 (Y)
FEEDBACK 显示每 x 行 (0) 的进度
FILESIZE 各转储文件的最大尺寸
QUERY 选定导出表子集的子句下列关键字仅用于可传输的表空间
TRANSPORT_TABLESPACE 导出可传输的表空间元数据 (N)
TABLESPACES 将传输的表空间列表
麻烦你可以把你测试过的命令行粘一下我看看好吗?
刚才试了一下能行^_^