Invalid Synonyms After Importing With Data Pump
(Doc ID 793609.1)
Last updated on SEPTEMBER 26, 2019
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
After a successful Data Pump import of a schema, synonyms from this schema are in INVALID status as shown by:
SELECT status, object_id, object_type, owner||'.'||object_name "OWNER.OBJECT"
WHERE status != 'VALID'
ORDER BY 4,2;
This does not happen with classic export / import.
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