Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[EXPORT] terminated successfully with warnings

Alfredo.LiardoMar 16 2014 — edited Mar 16 2014

Hi

I'm trying to export my oracle db, but when I type the command from DOS:

EXP system/password FILE=db_dump.dmp OWNER=admin LOG=log_db.log

it finish with :

export terminated succssfully with warnings

well, how do i see what are the warnings?

this is the log file:

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user ADMIN

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user ADMIN

About to export ADMIN's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

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

. . exporting table                     ACCESSORIO         31 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                       ACQUISTO         24 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                CLIENTE_TESSERA         15 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                       COLORATA         50 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                         COLORE         10 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                       CONTIENE        108 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                      FORNITORE         15 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                 HA_IN_CATALOGO        200 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                        LENTINA         24 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                      MONTATURA         38 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                         OCCHIO        128 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                        OMAGGIO         15 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                  OMAGGIO_VINTO          7 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                         ORDINE         13 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table                       PRODOTTO         93 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table            PRODOTTO_ACQUISTATO         29 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                   SCHEDA_ESAME         32 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.

when i try to restore the db with IMP command in the new database there isn't any tables.

what could be?thanks to all you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2014
Added on Mar 16 2014
4 comments
2,691 views