| Export warning [message #74117] |
Tue, 14 September 2004 10:23  |
hlin6688
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
I am exporting a subset of records in two tables into a file. The command i
use is:
exp usr/pass@db file=test.dat log=test.log tables=(table1, table2) query="where the_time
> oerr exp 91
00091, 00000, "Exporting questionable statistics."
// *Cause: Export was able export statistics, but the statistics may not be
// usuable. The statistics are questionable because one or more of
// the following happened during export: a row error occurred, client
// character set or NCHARSET does not match with the server, a query
// clause was specified on export, only certain partitions or
// subpartitions were exported, or a fatal error occurred while
// processing a table.
// *Action: To export non-questionable statistics, change the client character
// set or NCHARSET to match the server, export with no query clause,
// export complete tables. If desired, import parameters can be
// supplied so that only non-questionable statistics will be
imported,
// and all questionable statistics will be recalculated.
So from the "Cause" part, it says "a query clause was specified on export".
Does it mean whenever a query is used in the export command, the error will always happen?
Thanks in advance!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
