ITPub博客

首页 > 数据库 > Oracle > EXP导出分区数据

EXP导出分区数据

原创 Oracle 作者:Rman2017 时间:2017-04-19 09:42:35 0 删除 编辑

[oracle@localhost ~]$ exp test/test file=/home/oracle/mytestfenqu.dmp tables=mytest:T1,mytest:T2


Export: Release 10.2.0.4.0 - Production on Fri Mar 28 09:10:55 2014


Copyright (c) 1982, 2007, Oracle.  All rights reserved.



Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in ZHS16GBK character set and UTF8 NCHAR character set


About to export specified tables via Conventional Path ...

. . exporting table                         MYTEST

. . exporting partition                             T1          5 rows exported

. . exporting partition                             T2          4 rows exported

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31448824/viewspace-2137546/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 跟踪SESSION的方式
请登录后发表评论 登录
全部评论

注册时间:2017-03-30

  • 博文量
    352
  • 访问量
    132783