Oracle Error IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

Oracle Error Message

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

Reason for the Error

A table name was qualified with the name of its owner, as shown in the following example. This is not allowed. IMP SYSTEM/MANAGER TABLES=(SCOTT.EMP)

Solution

Use the FROMUSER parameter to specify the table’s owner, as shown in the following example: IMP SYSTEM/MANAGER FROMUSER=SCOTT TABLES=(EMP, DEPT)