Oracle export error

Looks like you have invalid packages in the export tools.  Try running utlrp.sql in the oracle_home admin directory to recompile your packages.  You may also need to rerun your catalog and catproc scripts.

Good luck.

yes i have executed, still same xport errors

Try running owminst.plb to recreate the LT_EXPORT_PKG package.

You also might want to try re-running catexp.sql.

at the time of execution owminst.plb, i got the below errors:

ORA-01920 user name wmsys conflicts with another user or role
.........
create type wmsys.wm$lock_info_type
ORA-00955: name is already used by an existing object
----------

like these i am getting lot of errors

and also i am geeting below msgs:
PL/SQL proc sucessfully create..
trigger sucessfully alterd..

what could be the reason?

select object_name, status from dba_objects where owner='sys' and object_name='lt_export_pkg'

output is showing:
'lt_export_pkg
valid

'lt_export_pkg
invalid

(why it was shwoing two status)

In dba_registry,

oracle workspace manger version is showing 9.2.0.1 0.

but my oracle version is 9.2.0.4.0.....this version is giving any problems?

and

oracle xml database status is shwing invalid

Change your select to:

select object_name, status,object_type from dba_objects where owner='sys' and object_name='lt_export_pkg'

That way you can see if it is the body, package or synonym.  Also run utlrp again if you haven't already.

Your workspace manager matches mine on a 9.2.0.4.0 rdbms so I think it is correct.

Good luck.

Hi mhenry20,

i have executed utlrp, no luck...same error.

WMSYS schema and lt_export_pkg is located in workspace manger right?  

I am not able to compile lt_export_pkg body, it was giving lot of errors related to wmsys_*.
The below mentioned scripts are executing successfully. But at the time of owminst.plb is giving errors related to wmsys_*.
1. Catproc.sql (Sucess).
2.Utlrp (Sucess)
3.catexp.sql (sucess).
4.catalog.sql (sucess).
5.owminst (fail).

this is related to wmsys/work space manger patches or something else?

I have executed below queryto find the version and status.
select comp_id,comp_name,version,status from dba_registry;

Output is:
all comp_name version is same (9.2.0.4.0),expect workspace manager (9.2.0.1.0),oracle XDK for java (9.2.0.6.0) (all are valid).

and xml database status is showing invalid

I am not sure, this is related to incompatible version or some other?
 

You could try uninstalling wmsys with owmuinst.plb, rerun catexp.sql and utlrep to see if that cleans it up.  After that if you need wmsys you could try installing it again.

I am closing this question because i found solution myself. This error is related to wmsys user not any packages.

thanks for your quick response.