export导出一条记录

尝试从数据库里导出一条记录,下面从不同系统导出一条记录：

[@more@]

1. windows 7:

C:Users123>exp hr/hr file=c:emp_1.dmp tables=hr.employees_t query="where rownum <= '1' "

Export: Release 11.2.0.3.0 - Production on 星期五 2月 1 10:08:29 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
服务器使用 AL32UTF8 字符集 (可能的字符集转换)

即将导出指定的表通过常规路径...
. . 正在导出表 EMPLOYEES_T导出了 1 行
EXP-00091: 正在导出有问题的统计信息。
导出成功终止, 但出现警告。

2. AIX 5.3

exp "/ as sysdba" tables=CASESURVEY.QUEST_SL_TEMP_EXPLAIN1,COREBASE.FEE_HIGH_SEARCH,

COREBASE.FILE_TEMPLATE,COREBASE.LAND_LONGTEXT,

COREBASE.LAND_OPINION,COREBASE.LAND_PARAMCONFIG,

COREBASE.LAND_PRINTFORM,COREBASE.LAND_SEND_CONTROL file=/oradata/user_1.dmp log=/oradata/user_1.log grants=n indexes=n statistics=none query=""where rownum <= '1' ""

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported

About to export specified tables via Conventional Path ...
Current user changed to CASESURVEY
. . exporting table QUEST_SL_TEMP_EXPLAIN1
Current user changed to COREBASE
. . exporting table FEE_HIGH_SEARCH 1 rows exported
. . exporting table FILE_TEMPLATE 1 rows exported
. . exporting table LAND_LONGTEXT 1 rows exported
. . exporting table LAND_OPINION 1 rows exported
. . exporting table LAND_PARAMCONFIG 1 rows exported
. . exporting table LAND_PRINTFORM 1 rows exported
. . exporting table LAND_SEND_CONTROL 1 rows exported
. . exporting table LSGIS_STAFF_T 0 rows exported
. . exporting table MMDATA 1 rows exported
. . exporting table SEL_RADIO_LIST_CONFIG 1 rows exported
Current user changed to DKNW
. . exporting table CK_ITEM_ARCHIVES 1 rows exported
. . exporting table TK_ITEM_ARCHIVES 1 rows exported
Current user changed to ECASE
. . exporting table E_SERMATERIAL 1 rows exported
Current user changed to EMAPCGGL
. . exporting table E_CHK_SERMATERIAL 1 rows exported
. . exporting table QUEST_SL_TEMP_EXPLAIN1

.......

..........

Export terminated successfully without warnings.

0条记录，是因为表是空表.

3. linux 5.3

[oracle@dbhouse ~]$ exp hr/hr file=/tmp/hr.dmp tables=hr.employees_t query="where rownum = '1' "

Export: Release 11.2.0.3.0 - Production on Fri Feb 1 18:18:11 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table EMPLOYEES_T 1 rows exported
Export terminated successfully without warnings.

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

转载于:http://blog.itpub.net/28227905/viewspace-1060184/