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***


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"
  "select sort_code,product_id "
  "from cb1.account_product@ewh"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel


Upgraded the Operating system to zOS 1.8

Applied Patches CPUAPR08 ( <>)  and latest OSDI modules version OSDI (patch for <> )


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