oracle@ipnmdb1:[/opt/app/oracle] exp
Export: Release 11.2.0.3.0 - Production on Tue May 12 15:40:49 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: rm ---账号
Password: ---密码
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Enter array fetch buffer size: 4096 > ---回车
Export file: expdat.dmp > ---导出的名字
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3 ---(选择3为表)
Export table data (yes/no): yes > ---回车
Compress extents (yes/no): yes > ---回车
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > rm_device --数据库中表的名称
. . exporting table RM_DEVICE 15994 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > rm_interface --数据库中表的名称
. . exporting table RM_INTERFACE 807182 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > ---回车退出
Export terminated successfully without warnings.
oracle@ipnmdb1:[/opt/app/oracle]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30273461/viewspace-1969220/,如需转载,请注明出处,否则将追究法律责任。