ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP 导出数据实例

EXP 导出数据实例

原创 Linux操作系统 作者:moonsoft 时间:2019-03-18 09:18:04 0 删除 编辑

导入的时候总是出现警告

C:Documents and SettingsAaron>exp system/manager@prod tables=GL.GL_balanceS
query=" where period_name='2009-07'" file=D:/EXP/GL_balanceS.dmp grants=y

Export: Release 10.2.0.1.0 - Production on Mon Aug 10 17:12:16 2009

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to GL
. . exporting table GL_BALANCES 3710 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

[@more@]

exp apps/apps@prod tables=GL.GL_JE_BATCHES query="where actual_flag='A' and creation_date>=sysdate-5" file=D:/EXP/GL_JE_BATCHES.dmp grants=y

exp system/manager@prod tables=GL.GL_JE_BATCHES query="where actual_flag='A' and creation_date>=sysdate-5" file=D:/EXP/GL_JE_BATCHES.dmp grants=y

exp system/manager@prod tables=GL.GL_JE_headerS query="where actual_flag='A' and creation_date>=sysdate-5" file=D:/EXP/GL_JE_headerS.dmp grants=y

exp system/manager@prod tables=GL.GL_JE_LINES query=" where creation_date>=sysdate-5" file=D:/EXP/GL_JE_LINES.dmp grants=y
exp system/manager@prod tables=GL.GL_SETS_OF_BOOKS file=D:/EXP/GL_SETS_OF_BOOKS.dmp grants=y

exp system/manager@prod tables=GL.GL_PERIODS query="where period_name = '2009-07'" file=D:/EXP/GL_PERIODS.dmp grants=y

exp system/manager@prod tables=GL.GL_CODE_COMBINATIONS query=" where summary_flag='N'" file=D:/EXP/GL_CODE_COMBINATIONS.dmp grants=y

exp system/manager@prod tables=GL.GL_balanceS query=" where period_name='2009-07'" file=D:/EXP/GL_balanceS.dmp grants=y

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

下一篇: SOX 了解
请登录后发表评论 登录
全部评论

注册时间:2005-01-20

  • 博文量
    412
  • 访问量
    418773