Import Gets Fails When Importing Views After Applying CPUJUL08 (Doc ID 729439.1)

Last updated on APRIL 24, 2017

Applies to:

Operating System Dependent Interface - Version: 1.2
Information in this document applies to any platform.
***Checked for relevance on 18-Jan-2010***

Symptoms

Import fails with ora-3113 when importing views with dblink and the remote database is running,

When the remote database is stopped the import works successfully.

The import log shows :
...
IMP-00017: following statement failed with ORACLE error 3113:
  "CREATE FORCE VIEW "CB2"."AP_VW"                             ("SORT_CODE","P"
  "RODUCT_ID") AS "
  "select sort_code,product_id "
  "from cb1.account_product@ewh"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms