If you are importing a dump file and the import simply hang on:

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE

or

Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION

or

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE

or

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY

or

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER

or

Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW

and so on,

In my case, most of the time the reason is that there are dblinks inside these objects and the DATABASE LINKS are not working on the target machine.

During the import, the database is trying to compile each objects but fails only after it gets a timeout for the connection. This could take even 2 minutes per object.

One workaround could be to exclude these object upfront (many times they are invalid anyway in the source DB)