exp 导出 Linux,EXP 导出数据实例

导入的时候总是出现警告

C:Documents and SettingsAaron>exp 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 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 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 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 tables=GL.GL_JE_LINES query=" where creation_date>=sysdate-5" file=D:/EXP/GL_JE_LINES.dmp grants=y

exp tables=GL.GL_SETS_OF_BOOKS file=D:/EXP/GL_SETS_OF_BOOKS.dmp grants=y

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

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

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