EXP 导出数据实例

导入的时候总是出现警告

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

请使用浏览器的分享功能分享到微信等