Removing Files & Folders from SOA MDS

There are scripts available over internet to remove the artifacts from MDS. But there are couple of other methods as well to achieve this without using script. And they are -

Remove entry from MDS_PATHS table -
Connect to SOA_MDS and search the table MDS_PATHS. This table holds the information of all the folder that are registered in MDS. Deleting an entry from this table will remove the artifact from the MDS as well. But the catch with this method is even if you remove the entry in this table there are various other related tables where the entry will still exist.

WLST deleteMetadata method -
WLST has deleteMetadata method that can be used to delete the file/folder from the MDS. It can be done through command line or from EM console as well.

Doing it command line way -

run (UNIX) MIDDLEWARE_HOME/ORACLE_SOA1/common/bin/wlst.sh

offline>connect('user','password','hostname:7001')
wls:/soa_domain/serverConfig> deleteMetadata(application='soa-infra',server='soa
_server1',docs='/apps/wsdl/*')

Executing operation: deleteMetadata.

Operation "deleteMetadata" completed. Summary of "deleteMetadata" operation is:

List of documents successfully deleted:
/apps/wsdl/test.wsdl

1 documents successfully deleted.

Doing it via EM console -

Right click soa-infra and goto MDS configuration as shown in image below.

 

 select "Runtime Configuration"

Then goto operations and click deleteMetadata.

Edit the docs and provide the similar arguments as shown in command line and click invoke. That should remove the folder as passed in the argument.