There is a table called MDS_PATHS where there would be entries corresponding to each artifact. I used to delete the entries from the table and the artifacts never used to show up, even though there will be entries in other related tables.
The best approach/solution is to use WLST command for cleaning up the MDS store. There is a function called deleteMetadata in WLST which will do the job for you.
This is how Oracle documentation describes the command. It deletes the selected documents from the application repository. When this command is run against repositories that support versioning, that is a database-based repository, delete is logical and marks the tip version (the latest version) of the selected documents as "deleted" in the MDS repository partition.
For more attributes and options available with the command refer this doc
The WLST script is located at:
Once the scripting tool is initialized, Connect to the server
For running deleteMetada function you need a minimum of 3 inputs
- application - since we are deleting from shared artifacts of soa-infra, the value should be soa-infra
- server - value should be ‘soa_server1’ or the server u use for SOA other than admin server.
- docs – the folder path or artifact which you want to delete.
Executing operation: deleteMetadata.
Operation "deleteMetadata" completed. Summary of "deleteMetadata" operation is:
List of documents successfully deleted:
1 documents successfully deleted.
This will be really useful in all projects as cleanup in mandatory in the MDS. Thanks to jithendra and Ram for their inputs.