My Oracle Support Banner

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

Last updated on AUGUST 31, 2023

Applies to:

Operating System Dependent Interface - Version 1.2 and later
Information in this document applies to any platform.

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 "<SCHEMANAME>"."XX_VW"                             ("SXXXXDE","P"
  "RXXXT_ID") AS "
  "select sXXXXe,pXXX "
  "from <SCHEMA>.tablename@DBLINK"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel



Changes

Upgraded the Operating system to zOS 1.8

Applied Patches CPUAPR08 ( <Bug 6926015>)  and latest OSDI modules version OSDI 1.2.1.1 (patch for <Bug 6138068> )

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.