如何用exp 导出 某个表的某几列数据

通过查询exp  help=y  的命令帮助信息,确实还没这项功能 10g好像也没有这功能

不过我们可以变通一下 达到我们的需要 通过create table  tablename as select 方法

测试如下:

C:\Documents and Settings\Paul Yi>sqlplus paul/paul

SQL*Plus: Release 9.2.0.4.0 - Production on Mon May 26 10:14:51 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

~+C]\t2i \/M
B0Connected to:
%m%tD2k2qPM0Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
t;i(D![%H/?0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间+A/i'O,?\H
JServer Release 9.2.0.4.0 - Production

SQL> create table test as select * from user_objects;

Table created.

SQL> desc test;ITPUB个人空间*Q9N:qhE/gd
 Name                                      Null?    TypeITPUB个人空间.J UK9j2b
 ----------------------------------------- -------- ----------------------------

 OBJECT_NAME                                        VARCHAR2(128)ITPUB个人空间,X;g%]:y1WvGipq+Z
 SUBOBJECT_NAME                                     VARCHAR2(30)ITPUB个人空间.V:E-E6`'B2wn!^w
 OBJECT_ID                                          NUMBER
7^ k FM;P \[0 DATA_OBJECT_ID                                     NUMBERITPUB个人空间1W8X!JZd#ise
 OBJECT_TYPE                                        VARCHAR2(18)ITPUB个人空间-xV-cSw
 CREATED                                            DATE
Z8d o:SG]0 LAST_DDL_TIME                                      DATE
7W1}*TV8R5I ^P0 TIMESTAMP                                          VARCHAR2(19)ITPUB个人空间 _ A8K&m1U@&@)f p
 STATUS                                             VARCHAR2(7)ITPUB个人空间b'S+bP_#m3N
 TEMPORARY                                          VARCHAR2(1)
]no)d
LC+{0 GENERATED                                          VARCHAR2(1)ITPUB个人空间 E/~/L8D'^`8r7N
 SECONDARY                                          VARCHAR2(1)

SQL> select count(*) from test;

  COUNT(*)
)o-jT2Lyh/V8l?BI$e0----------ITPUB个人空间M0}z7`;Pd+~2TTx
        25

假设我们导出只需要object_id,object_name 两个字段的数据

SQL>create table test_column as select object_id,object_name from test;

Table created.

SQL>

C:\Documents and Settings\Paul Yi>exp paul/paul tables=(test_column) file=c:\tes
U@v+SVD0t.dmp log=c:\test.log buffer=10240000

Export: Release 9.2.0.4.0 - Production on Mon May 26 10:19:54 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

0S1i)_J*q/x+Kf
g0Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
9Lt3zX]a8Wd8Y0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间g;^.y,M2hsK9^^
JServer Release 9.2.0.4.0 - ProductionITPUB个人空间2F$]8\~a2]
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...ITPUB个人空间4V do g:D
. . exporting table                    TEST_COLUMN         25 rows exported
Aj | @[0Export terminated successfully without warnings.

C:\Documents and Settings\Paul Yi>