Diff QUERY= syntax in EXP PARFILE for 8.1.7 -vs- 10.2?
Date: Fri, 12 Sep 2008 10:43:48 -0700 (PDT)
Message-ID: <b85eced9-149f-4d4c-9dc2-d6c848737722@b1g2000hsg.googlegroups.com>
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.
Received on Fri Sep 12 2008 - 12:43:48 CDT