My Oracle Support Banner

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

Last updated on JANUARY 05, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.