Invalid Xml Schema Objects Owned by XDB User After Full Export/Import (Doc ID 757855.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
Checked for relevance on 02-Dec-2011

This article is applicable for Oracle 10g or higher release only.

Symptoms

After doing a full export/import of the database, there are several invalid XML SCHEMA objects, e.g. - 

OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ -------------------
----------------------------------------------------------------------------------------------------
----------------------------
XDB XML SCHEMA XDWj7mLBTB0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBUm0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBVu0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBWD0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBW10FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBXU0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBXm0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBXw0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBX30FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBX+0FbgQ6wQFBvQVg==
XDB XML SCHEMA XDWj7mLBYF0FbgQ6wQFBvQVg==
:
:
30 rows selected

Changes

All objects were valid before executing the import, after import they became invalid.

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