hi,
i think your first objective is to fix your oracle xml component issue.
first, please provide the output of this query:
select COMP_NAME,VERSION,STATUS from dba_registry;
* this will list all of your oracle components and will show if XML component is "invalid".
Then, try to know the root cause of why XDB invalidation, through this query:
select owner, object_type, object_name
from dba_objects where status <>'VALID' and owner='XDB';
* it will list all (packages,procedures,views,...etc) that are having the issue under 'XDB' schema.
then, next step is to find out what is the issue with each (package,procedure,...etc) you got from the previous query. You can do
that either through sql developer or TOAD. by going under the xdb schema and trying to compile these objects and
check the "error" tab it will show what is causing this issue (it could be a permission issue for 'xdb' schema).
if you don't have Toad or sql developer then, use the following query:
select text from dba_errors where name = â??[OBJECT_NAME]â?? and owner = â??XDBâ??;
Where [OBJECT_NAME] is then name of Database object which is having the problem.
Try to export again after fixing the issue.
Hope This helps.
Regards,
Emad Al-Mousa