How to fix the Oracle error IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter?

In this post, you’ll learn more about the Oracle ErrorIMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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)

How to fix the Error IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter ?

You can fix this error in Oracle by following the below steps

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