RE: Expdp a subset of fields from a table
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <richa03@xxxxxxxxx>
- Date: Mon, 29 Jun 2009 14:32:34 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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@xxxxxxxxxxxxxxxxxxxx> wrote:
Just include a select in your expdp command/parfile.
QUERY = <schema>.<table>: SELECT .
_____
Other related posts:
