Schema Import Fails With Error PLS-201 Identifier SYS.DBMS_EXPORT_EXTENSION Must Be Declared [ID 445135.]
SymptomsSchema import fails with errors:
1. Grant execute on DBMS_EXPORT_EXTENSION to public.
2. Grant execute on DBMS_EXPORT_EXTENSION to the user/schema you are importing into (not the user who is running the import). For example, if you are importing into schema CDM_DB0 then grant execute to that user..