[oracle@gxt-db u01]$ expExport: Release 10.2.0.1.0 - Production on Thu Jan 28 21:46:57 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: gaoxt
Password:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >Export file: expdat.dmp > gaoxtDB_2010-01-28.dmp(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > UExport grants (yes/no): yes > yesExport table data (yes/no): yes > yesCompress extents (yes/no): yes > yesExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified users ...
User to be exported: (RETURN to quit) >Export terminated successfully without warnings.
[oracle@gxt-db u01]$
如果导出其它帐户,请用命令行指定owner参数吧
如:
exp system/manager@tnsname file=test.dmp owner=(scott)
但是只用"exp" 然后按提示一步一步导出 就导不出数据,只导出了字符集 是不是用exp 提示一步一步导出就存在这种问题呢?
http://blog.csdn.net/tianlesoftware/archive/2009/10/24/4718366.aspx