How to fix the Oracle error IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created?

In this post, you’ll learn more about the Oracle ErrorIMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created

Reason for the Error IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created

An error occurred creating a synonym for a type that is used by the

* table.

How to fix the Error IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created ?

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

Examine the import log to determine why the type synonym could

* not be created. If the synonym already existed, but is not

* needed, then drop the synonym and retry the import. If the

* synonym is PUBLIC but the importer does not have the

* CREATE PUBLIC SYNONYM system privilege, then the import must

* be done by someone possessing that privilege, or the importer

* must be granted the privilege.