When you are the MDS of the SOA Suite you probably added some files by mistake which where not mend to be in there. If it is a file based MDS…..no problem. Just delete them from the file system. But when it is a database based MDS, you have to do a bit more. One way is to use WLST to remove the files. Go to MIDDLEWARE_HOME/Oracle_soa1/common/bin and start wlst.sh. The next thing to do is open a connection. This goes like this:
connect('MY_USERNAME' , 'MY_PASSWORD', 't3://MY_SERVER:7001')
The WLST console should tell you that your are succesfully connected now.
Next you might want to delete all the files under a certain directory say common. You can use this by using the DeleteMetadata function. It works likes this:
deleteMetadata(application='soa-infra',server='soa_server1',docs='/apps/common/*')
Now…..all the files under the common directory should be gone. For the full explanation of deleteMetadata see here
Great post, thank you! Do you know how to delete a directory in MDS (i.e. /apps/common/ABC) ?
I think you can use sca_removeSharedData for removing a complete structures. See this link for details: http://docs.oracle.com/cd/E14571_01/web.1111/e13813/custom_soa.htm#CDECECFH