Expdp a subset of fields from a table

From: Rich <richa03@xxxxxxxxx>
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 29 Jun 2009 09:00:59 -0700

Hello list,

Is there any way to export a subset of fields from a table using expdp?

Say, for example, we have dba_objects which is:
OWNER                                              VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(128)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                          NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(19)
 CREATED                                            DATE
 LAST_DDL_TIME                                      DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)

and I would like to export just:
OWNER                                              VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(128)
 SUBOBJECT_NAME                                     VARCHAR2(30)

We are trying to prove expdp is having an issue with just the LOB data of a
business table - we have already checked for corruption.

Thanks,
Rich

Follow-Ups:

RE: Expdp a subset of fields from a table
From: Michael McMullen

Expdp a subset of fields from a table

Other related posts: