exp 用法参考如下:Export: Release 8.1.6.0.0 - Production on Wed Nov 6 11:45:38 2002(c) Copyright 1999 Oracle Corporation. All rights reserved.You can let Export prompt you for parameters by entering the EXP
command followed by your username/password: Example: EXP SCOTT/TIGEROr, 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 tableUSERID 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)
ROWS export data rows (Y) PARFILE parameter filename
CONSTRAINTS export constraints (Y) CONSISTENT cross-table consistency
LOG log file of screen output STATISTICS analyze objects (ESTIMATE)
DIRECT direct path (N) TRIGGERS export triggers (Y)
FEEDBACK display progress every x rows (0)
FILESIZE maximum size of each dump file
QUERY select clause used to export a subset of a tableThe following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TABLESPACES list of tablespaces to transportExport terminated successfully without warnings.
示例:
exp test/test@sun FILE=test.dmp COMPRESS=Y GRANTS=Y INDEXES=Y ROWS=N LOG=test.txt TRIGGERS=Y
command followed by your username/password: Example: EXP SCOTT/TIGEROr, 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 tableUSERID 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)
ROWS export data rows (Y) PARFILE parameter filename
CONSTRAINTS export constraints (Y) CONSISTENT cross-table consistency
LOG log file of screen output STATISTICS analyze objects (ESTIMATE)
DIRECT direct path (N) TRIGGERS export triggers (Y)
FEEDBACK display progress every x rows (0)
FILESIZE maximum size of each dump file
QUERY select clause used to export a subset of a tableThe following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TABLESPACES list of tablespaces to transportExport terminated successfully without warnings.
示例:
exp test/test@sun FILE=test.dmp COMPRESS=Y GRANTS=Y INDEXES=Y ROWS=N LOG=test.txt TRIGGERS=Y
我的exp错了马?能不能够给我个解释,很多资料都是这样写的,而且就是表不能够导入!谢谢!
D:\>exp system/manager owner=(用户1,用户2,…,用户n) file=导出文件
(确定你的导出程序为exp.exe)
你可以试着用这两种方法导出
我想应该是你设的增量标识有些问题
也不是imp的问题,而是建立用户的问题,建用户的时候只有角色,没有系统权限,结帐了,全部都有分! zero88(零点) 你给了我启发亚!