데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

Cause: Export was able to export statistics, but the statistics may not be useable. 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, or 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.

==============================================================

Shell 작업 화면.

==============================================================

[juihn@stere juihn]$ exp userid=stere/****** file=stere.dmp

Export: Release 9.2.0.1.0 - Production on 수 Feb 26 16:18:31 2003

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

Export done in KO16KSC5601 character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user STERE

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user STERE

About to export STERE's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export STERE's tables via Conventional Path ...

. . exporting table BOARDS 12 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table BOARDSC 2 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table BROWSE 560 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table CALENDAR 28 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table CONTACTS 379 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table LISTCOUNTRY 238 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table LISTLUNAR 109938 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table LOGMACHINES 1234 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table LOGPAGES 25722 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table LOGUSERS 998 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table MACHINES 339 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table MP3 521 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table MP3LOG 2567 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table NOTES 245 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table USERS 20 rows exported

EXP-00091: Exporting questionable statistics.

. exporting synonyms

. exporting views

. exporting stored procedures

. exporting operators

. exporting referential integrity constraints

. exporting triggers

. exporting indextypes

. exporting bitmap, functional and extensible indexes

. exporting posttables actions

. exporting materialized views

. exporting snapshot logs

. exporting job queues

. exporting refresh groups and children

. exporting dimensions

. exporting post-schema procedural objects and actions

. exporting statistics

Export terminated successfully with warnings.

[juihn@stere juihn]$

==============================================================

이 글에 대한 댓글이 총 1건 있습니다.

Export terminated successfully with warnings

메세지는 경고와 함께 정상적으로 성공은 했다는군요.

그리고 다음을 참조

Fact(s)

~~~~~~~~

Oracle Server - Enterprise Edition 9.0.1

Oracle Server - Enterprise Edition 9.2.0

Symptom(s)

~~~~~~~~~~

EXP-00091: Exporting questionable statistics.

Cause

~~~~~~~

In Oracle 9i by default export attempts to include statistic

s in the export.

In pre Oracle 9i versions statistics are not included unless

it is specified.

Reference:

Bug 1862413 EXPORT & DEFAULT FOR STATISTICS SHOULD BE PRE-9

I COMPATIBLE

Note 159787.1 9i: Import STATISTICS=SAFE

Fix

~~~~

a) If the statistics of a table are not required to include

in export

take the export with parameter STATISTICS=NONE

Example:

$exp scott/tiger file=emp1.dmp tables=emp STATISTICS=NONE

b) In case, the statistics are need to be included can use S

TATISTICS=ESTIMATE or

COMPUTE (default is Estimate).

kk님이 2003-02-26 18:16에 작성한 댓글입니다.

[Top]

No.	제목	작성자	작성일	조회
13655	두 테이블을 조인해야 하는데 어케 하는지.. [1]	어려버	2003-02-27	870
13654	database생성 수동으로하는게 [1]	오라클요	2003-02-26	1278
13653	imp시 INITIAL 확장 영역에대한 에러가 납니다. [1]	영스	2003-02-26	1435
13652	error: EXP-00091: Exporting questionable statistics. [1]	오주인	2003-02-26	3187
13651	다음 에러 해결좀... [2]	최재완	2003-02-26	2133
13650	배열 insert 관련 질문 입니다. [1]	김선훈	2003-02-26	3011
13649	스키마만 exp시킬순없나여? [1]	영스	2003-02-26	1135

작업시간: 0.017초, 이곳 서비스는
PostgreSQL v16.2로 자료를 관리합니다