Database Utilities (MOSC)

MOSC Banner

IMP returns "Import terminated successfully without warnings."

edited Sep 30, 2014 6:33AM in Database Utilities (MOSC) 6 commentsAnswered

There is a dump file exported by others. Now I run imp command to import dump file into another database.

The version of imp command is 10.2.0.3 and its environments are: export NLS_LANG=american_america.zhs16gbk, export LANG=en_US.UTF-8

Run the command:

imp abc/abc file=/oracle/oradata_orac2p/exp/abc.dmp log=/oracle/oradata_orac2p/imp/abc.log fromuser=netiq touser=abc ignore=y commit=y buffer=300000000 feedback=100000

It only display the following information after several hours:

"Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning and Data Mining options

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center