My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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.