EXP-00091: Exporting questionable statistics.
---------------------------------------------
-------TO ABOID following message when export data.
cmd> set NLS_LANG=.WE8MSWIN1252 SQL>
example:
C:\Users\Halimm>sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm
Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table ADDRESS 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table AVAILABILITY_CALENDAR 2213 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table BACKUP_SECURITY_USER 2372 rows exported
. . exporting table COMPANY 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table CONTACT 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table COUNTY_TYPE 161 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DIVISION_TYPE 14 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTIONAL_ROLE_TYPE 43 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTIONAL_USER_ROLE 451 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table HOLIDAY_TYPE 64 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table LEAVE_CALENDAR 231 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table MIG_LOG 26 rows exported
. . exporting table MIG_ROLE_TYPE_IS_JUDGE_SECRE 78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS 92 rows exported
. . exporting table OFFICE_LOCATION_TYPE 10 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table POSITION_TYPE 33 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_DETAIL 1900 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_QUESTION 3 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_ROLE_TYPE 39 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_USER 2385 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_CALENDAR 6831 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_COUNTY 527 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_SLOT 40105 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_TYPE 98 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SLOT_TYPE 8 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table STATE_TYPE 50 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_COUNTY 1058 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_CREDENTIAL 2242 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_GROUP 111 rows exported
. . exporting table USER_STATUS_TYPE 6 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.
SQL>
SQL>
SQL>
SQL>
SQL> exit
C:\Users\Halimm>set NLS_LANG=.WE8MSWIN1252
C:\Users\Halimm>
C:\Users\Halimm>sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm
Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table ADDRESS 2384 rows exported
. . exporting table AVAILABILITY_CALENDAR 2213 rows exported
. . exporting table BACKUP_SECURITY_USER 2372 rows exported
. . exporting table COMPANY 2384 rows exported
. . exporting table CONTACT 2384 rows exported
. . exporting table COUNTY_TYPE 161 rows exported
. . exporting table DIVISION_TYPE 14 rows exported
. . exporting table FUNCTIONAL_ROLE_TYPE 43 rows exported
. . exporting table FUNCTIONAL_USER_ROLE 451 rows exported
. . exporting table HOLIDAY_TYPE 64 rows exported
. . exporting table LEAVE_CALENDAR 231 rows exported
. . exporting table MIG_LOG 26 rows exported
. . exporting table MIG_ROLE_TYPE_IS_JUDGE_SECRE 78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS 92 rows exported
. . exporting table OFFICE_LOCATION_TYPE 10 rows exported
. . exporting table POSITION_TYPE 33 rows exported
. . exporting table SECURITY_DETAIL 1900 rows exported
. . exporting table SECURITY_QUESTION 3 rows exported
. . exporting table SECURITY_ROLE_TYPE 39 rows exported
. . exporting table SECURITY_USER 2385 rows exported
. . exporting table SITE_CALENDAR 6831 rows exported
. . exporting table SITE_COUNTY 527 rows exported
. . exporting table SITE_SLOT 40105 rows exported
. . exporting table SITE_TYPE 98 rows exported
. . exporting table SLOT_TYPE 8 rows exported
. . exporting table STATE_TYPE 50 rows exported
. . exporting table USER_COUNTY 1058 rows exported
. . exporting table USER_CREDENTIAL 2242 rows exported
. . exporting table USER_GROUP 111 rows exported
. . exporting table USER_STATUS_TYPE 6 rows exported
. 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 without warnings.
SQL>
---------------------------------------------
-------TO ABOID following message when export data.
cmd> set NLS_LANG=.WE8MSWIN1252 SQL>
example:
C:\Users\Halimm>sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm
Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table ADDRESS 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table AVAILABILITY_CALENDAR 2213 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table BACKUP_SECURITY_USER 2372 rows exported
. . exporting table COMPANY 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table CONTACT 2384 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table COUNTY_TYPE 161 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DIVISION_TYPE 14 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTIONAL_ROLE_TYPE 43 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTIONAL_USER_ROLE 451 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table HOLIDAY_TYPE 64 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table LEAVE_CALENDAR 231 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table MIG_LOG 26 rows exported
. . exporting table MIG_ROLE_TYPE_IS_JUDGE_SECRE 78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS 92 rows exported
. . exporting table OFFICE_LOCATION_TYPE 10 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table POSITION_TYPE 33 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_DETAIL 1900 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_QUESTION 3 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_ROLE_TYPE 39 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SECURITY_USER 2385 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_CALENDAR 6831 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_COUNTY 527 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_SLOT 40105 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SITE_TYPE 98 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table SLOT_TYPE 8 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table STATE_TYPE 50 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_COUNTY 1058 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_CREDENTIAL 2242 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USER_GROUP 111 rows exported
. . exporting table USER_STATUS_TYPE 6 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.
SQL>
SQL>
SQL>
SQL>
SQL> exit
C:\Users\Halimm>set NLS_LANG=.WE8MSWIN1252
C:\Users\Halimm>
C:\Users\Halimm>sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:03 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> $exp icms_stage\icms_stage file=C:\halim_documents\icms2_dump\icms_stage_14022014.dmp owner=icm
Export: Release 10.2.0.5.0 - Production on Fri Feb 14 16:36:15 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICMS_STAGE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICMS_STAGE
About to export ICMS_STAGE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ICMS_STAGE's tables via Conventional Path ...
. . exporting table ADDRESS 2384 rows exported
. . exporting table AVAILABILITY_CALENDAR 2213 rows exported
. . exporting table BACKUP_SECURITY_USER 2372 rows exported
. . exporting table COMPANY 2384 rows exported
. . exporting table CONTACT 2384 rows exported
. . exporting table COUNTY_TYPE 161 rows exported
. . exporting table DIVISION_TYPE 14 rows exported
. . exporting table FUNCTIONAL_ROLE_TYPE 43 rows exported
. . exporting table FUNCTIONAL_USER_ROLE 451 rows exported
. . exporting table HOLIDAY_TYPE 64 rows exported
. . exporting table LEAVE_CALENDAR 231 rows exported
. . exporting table MIG_LOG 26 rows exported
. . exporting table MIG_ROLE_TYPE_IS_JUDGE_SECRE 78 rows exported
. . exporting table MIG_SECURITY_ROLE_TYPE_DETAILS 92 rows exported
. . exporting table OFFICE_LOCATION_TYPE 10 rows exported
. . exporting table POSITION_TYPE 33 rows exported
. . exporting table SECURITY_DETAIL 1900 rows exported
. . exporting table SECURITY_QUESTION 3 rows exported
. . exporting table SECURITY_ROLE_TYPE 39 rows exported
. . exporting table SECURITY_USER 2385 rows exported
. . exporting table SITE_CALENDAR 6831 rows exported
. . exporting table SITE_COUNTY 527 rows exported
. . exporting table SITE_SLOT 40105 rows exported
. . exporting table SITE_TYPE 98 rows exported
. . exporting table SLOT_TYPE 8 rows exported
. . exporting table STATE_TYPE 50 rows exported
. . exporting table USER_COUNTY 1058 rows exported
. . exporting table USER_CREDENTIAL 2242 rows exported
. . exporting table USER_GROUP 111 rows exported
. . exporting table USER_STATUS_TYPE 6 rows exported
. 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 without warnings.
SQL>
No comments:
Post a Comment