RE: Expdp a subset of fields from a table

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 29 Jun 2009 14:32:34 -0400
Message-ID: <BAY115-DAV6B6CE614A5C49A38A9039A6300_at_phx.gbl>
Message-ID: <3DC3609B033D4FDAB2381164BA56A88A_at_vpmcm01>

I've always thought that performance and ora-1555 go hand in hand, slow query on changing data, odds are you see ora-1555 but I also get these on my lob tables even when there have been no data changes for hours. Look at delayed block cleanout. You could always trace the session or set an event on ora-1555 to make sure. It could even be an underlying index causing the errors. Most of our data is bulk loaded so we usually do a combination of undo_retention,fts on the data, analyze all data and analyze all indexes to avoid the error. Delayed block cleanouts are supposed to be rare but I run into it all the time.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich
Sent: Monday, June 29, 2009 1:33 PM
To: Blanchard, William
Cc: Oracle-L Freelists
Subject: 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_at_societyinsurance.com> wrote:

Just include a select in your expdp command/parfile.  

QUERY = <schema>.<table>: SELECT .  

---

 

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 29 2009 - 13:32:34 CDT