Re: Expdp a subset of fields from a table

From: Rich <richa03_at_gmail.com>
Date: Mon, 29 Jun 2009 10:32:56 -0700
Message-ID: <26279fb90906291032m11c690d5pd9bf731a7c386bab_at_mail.gmail.com>



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_at_societyinsurance.com> wrote:

> Just include a select in your expdp command/parfile.
>
>
>
> QUERY = <schema>.<table>: SELECT
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 29 2009 - 12:32:56 CDT

Original text of this message