ITPub博客

首页 > 数据库 > Oracle > oracle 导出表数据

oracle 导出表数据

原创 Oracle 作者:1362336695 时间:2015-12-31 16:04:37 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/30273461/viewspace-1969220/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: AIX 常用命令汇总
请登录后发表评论 登录
全部评论

注册时间:2015-06-04

  • 博文量
    61
  • 访问量
    107271