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.

John L. Allen wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

John L. Allen wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

John L. Allen wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

John L. Allen wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Sep 12, 10:43*am, "John L. Allen" <allen... (AT) mail (DOT) northgrum.com>
wrote:
Just a wild guess, have you tried a backslash before the dollar sign?
And I agree with Daniel, be sure the query works with sqlplus.

jg
--
@home.com is bogus.
Why did the housekeepers rewind all my half-watched tapes?

On Sep 12, 10:43*am, "John L. Allen" <allen... (AT) mail (DOT) northgrum.com>
wrote:
Just a wild guess, have you tried a backslash before the dollar sign?
And I agree with Daniel, be sure the query works with sqlplus.

jg
--
@home.com is bogus.
Why did the housekeepers rewind all my half-watched tapes?

On Sep 12, 10:43*am, "John L. Allen" <allen... (AT) mail (DOT) northgrum.com>
wrote:
Just a wild guess, have you tried a backslash before the dollar sign?
And I agree with Daniel, be sure the query works with sqlplus.

jg
--
@home.com is bogus.
Why did the housekeepers rewind all my half-watched tapes?

On Sep 12, 10:43*am, "John L. Allen" <allen... (AT) mail (DOT) northgrum.com>
wrote:
Just a wild guess, have you tried a backslash before the dollar sign?
And I agree with Daniel, be sure the query works with sqlplus.

jg
--
@home.com is bogus.
Why did the housekeepers rewind all my half-watched tapes?

On Sat, 13 Sep 2008 08:46:14 -0700 (PDT), joel garry
<joel-garry (AT) home (DOT) com> wrote:

Joel,

You should send this to Matt Groening for Bart's whiteboard gag!!

Works perfectly if you revise it to

I will not rewind my half-watched (Itchy and Scratchy) tapes

--
Sybrand Bakker
Senior Oracle DBA