Import terminated successfully without warnings – But no Object imported

Scenario: We have got the Dump from remote site and they have mentioned that dump was exported from SYSTEM user.

we tried the following two option but none of the expected object was imported to “bbb” schema

[oracle@UNIX backup]$ imp userid=system/xxxx fromuser=aaa touser=bbb file=backup.dmp log=export-1.log

[oracle@UNIX backup]$ imp userid=system/xxxx fromuser=system touser=bbb file=backup.dmp log=export-1.log

[oracle@UNIX backup]$ tail -1 imp.log
Import terminated successfully without warnings.
[oracle@UNIX backup]$

Import log says import completed successfully but it is not showing any object getting imported in log also.

We have tried with show=y option to see the content but still it is not showing.

Cause :
It is because we have expected objects in “CCCC” user at remote site. When engineer exported the dump
he used system user and did the full export of the database.

Solution
Since the remote site DBA used full export from system user and we need object from “CCCC” we have to do any of the following option

1. Do Full Import against the target database
or
2. Import command with the fromuser=”CCCC”

How do you find out the which user have the object you required without remote site enginner inform you. Only option is edit
the dump file in any editor if it is small. If not cat the file with more
$ cat backup.dmp |more
Look for the word CONNECT CCCC

Comments are closed.