Question about the err when export table - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Question about the err when export table

Question about the err when export table# Database - 数据库

g*l2004-09-14 07:09

1 楼

I am exporting a subset of records in two tables into a file. The command i
use
is:
exp usr/[email protected] 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*h2004-09-14 07:09

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/[email protected] 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