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!

exp from 9 to imp to 11g R2

happy10319Mar 29 2012 — edited Mar 29 2012

Hi,
on 9i on Win 2000 I export like this :

exp scott/tiger@orcl FILE=EXP_SCOTT LOG=EXP_SCOTT_LOG
.................................................................
.............................................................
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                       SALGRADE          5 rows exported
. . exporting table                             T1          1 rows exported
. exporting synonyms
. .......
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.

And imported :

imp user23/****@orcl FILE=D:\bases\orcl\EXP_SCOTT.DMP LOG=M:\bases\orcl\IMP_SCOTT_user23_LOG

import terminated successfully

C:\Users\>sqlplus user23@orcl
connected
SQL> select table_name from user_tables;
no rows selected

What was wrong in my exp/import ?

Thank you.

This post has been answered by Think_dba on Mar 29 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2012

Added on Mar 29 2012

#database-key-features, #export-import-sql-loader-external-tables

1 comment

195 views