To delete the metadata, purge the metadata for the resource from the Metadata Manager warehouse. Metadata Manager purges all metadata from the warehouse. Purging metadata may take some time, based on the amount of metadata loaded for the resource. After you purge a resource, you can optimize the index to free up disk space used by the indexing files.

When the Metadata Manager warehouse uses Oracle database, you need to assign the CREATE TABLE and EXECUTE PROCEDURE permissions to the user. When you assign the

GRANT CREATE TABLE TO <MM_DB_USER>

permission, make sure you assign the permission to the user or schema of the Metadata Manager warehouse.