g*******l
发帖数: 6 | 1 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\
The command was running but it gave follow error:
"
Export: Release 9.2.0.4.0 - Production on Tue Sep 14 07:10:52 2004
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Expor | m**h
发帖数: 69 | 2 Stats is generated for the optimizer choosing the "best" execution plan.
No worry about the STATISTICS=NO, you'd better to update the
stats after the import for partial data anyway, like:
analyze table table1 estimate/compute statistics;
or do all on the schema level.
【在 g*******l 的大作中提到】
: 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\: The command was running but it gave follow error:
: "
: Export: Release 9.2.0.4.0 - Production on Tue Sep 14 07:10:52 2004
: Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
: With the Partitioning, OLAP and Oracle Data Mining options
|
|
