oracle 导出表数据

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30273461/viewspace-1969220/