Re: Diff QUERY= syntax in EXP PARFILE for 8.1.7 -vs- 10.2?

John L. Allen wrote:
> Hi,
>
> I am wondering why an exp command works with Oracle 8.1.7, but not
> with Oracle 10.2.0.4. Here's my input file and the exp command that
> uses it:
>
> $ cat inp3.exp
> FILE=/tmp/confitem.dat
> LOG=/tmp/confitem.log
> TABLES=( \"VPMADM.configuration_item_\" )
> BUFFER=40000
> TRIGGERS=N
> GRANTS=N
> INDEXES=N
> ROWS=Y
> QUERY="where \"$COID\" = '414199C0C52A6416'"
>
> $ exp vpmadm/xxxxxxxx parfile=inp3.exp
>
>
> Here's the successful output with 8.1.7:
>
> Export: Release 8.1.7.4.0 - Production on Fri Sep 12 13:32:29 2008
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 -
> Production
> With the Partitioning option
> JServer Release 8.1.7.4.0 - Production
> Export done in US7ASCII character set and US7ASCII NCHAR character set
> Note: grants on tables/views/sequences/roles will not be exported
> Note: indexes on tables will not be exported
>
> About to export specified tables via Conventional Path ...
> . . exporting table configuration_item_ 1 rows
> exported
> Export terminated successfully without warnings.
>
>
> And here's the error with 10.2.0.3:
>
> LRM-00111: no closing quote for value '
> '
> LRM-00113: error when processing file 'inp3.exp'
>
> EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
> EXP-00000: Export terminated unsuccessfully
>
>
> It appears to be complaining about the QUERY line:
>
> QUERY="where \"$COID\" = '414199C0C52A6416'"
>
> And yes, the field name is really $COID, which seems to be crux of the
> problem.
>
> I've tried various versions of this line without success. The
> closest I can get to running is with
>
> QUERY="where '$COID' = '414199C0C52A6416'"
>
> but it's not exporting anything like it should:
>
>
> Export: Release 10.2.0.3.0 - Production on Fri Sep 12 13:36:33 2008
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> Connected to: Oracle Database 10g Enterprise Edition Release
> 10.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Data Mining options
> Export done in US7ASCII character set and UTF8 NCHAR character set
> server uses WE8ISO8859P1 character set (possible charset conversion)
> Note: grants on tables/views/sequences/roles will not be exported
> Note: indexes on tables will not be exported
>
> About to export specified tables via Conventional Path ...
> . . exporting table configuration_item_ 0 rows
> exported
> EXP-00091: Exporting questionable statistics.
> Export terminated successfully with warnings.

What's the issue you are seeing? Are you sure configuration_item_ has rows that should have been exported? The warning you received is just telling you that Oracle believes your statistics are not current.

PS: At the top you said you were exporting from 10.2.0.4 but your sample shows 10.2.0.3. Are we looking at the right thing?

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org