Duplicate Types In DBA_TYPES After Import (IMP) (Doc ID 555217.1)

Last updated on DECEMBER 10, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.5 [Release 9.2 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2014***

Symptoms

After database import, duplicate types are found in dba_types.

Steps to perform the import:

To reproduce the issue:

1. create a test schema and a package with pipelined functions:

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