Re: Expdp a subset of fields from a table

Hi William,
I tried that:
$ORACLE_HOME/bin/expdp `/home/oracle/dbserver_dba` TRACE=480300
DIRECTORY=DPUMP_DIR_IMP1 \
DUMPFILE=HSR_TRANSLATION_HISTORY_TIER2_NO_LOB_`date +%d%b%Y`.expdp \
TABLES='HSR_TRANSLATION_HISTORY_TIER2' \
QUERY=HSR_TRANSLATION_HISTORY_TIER2\:\"select TRHS_PKEY, TRHS_SEQ, TRAN_KEY,
TRSP_KEY, TRHS_DESC, TRHS_DOC_URL, TRHS_DOC_SIZE, TRHS_CREATED_DATE,
TRHS_CONTENT_TYPE, TRHS_ZIPPED, BSTP_GUID, TRHS_INHERITABLE from
HSR_TRANSLATION_HISTORY_TIER2\" \
logfile=HSR_TRANSLATION_HISTORY_TIER2_NO_LOB_`date +%d%b%Y`_expdp.log

I get ORA-00933: SQL command not properly ended

Hi Michael,
It's not a performance issue, 1555 issue.
We checked for corruption in the LOB area to no avail and Oracle is saying
they think it might be the table segment, not the LOB segment.
I asked in the SR, however, thought I'd ask here, also.



On Mon, Jun 29, 2009 at 10:10 AM, Blanchard, William <
wblanchard@xxxxxxxxxxxxxxxxxxxx> wrote:

>  Just include a select in your expdp command/parfile.
>
>
>
> QUERY = <schema>.<table>: SELECT …
>
>
>  ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Rich
> *Sent:* Monday, June 29, 2009 11:01 AM
> *To:* Oracle-L Freelists
> *Subject:* Expdp a subset of fields from a table
>
>
>
> 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
>
> -
>
> This email and any information, files, or materials transmitted with it
> are confidential and are solely for the use of the intended recipient.
> If you have received this email in error, please delete it and notify
> the sender.
>
>
>

Other related posts: