How to clean up old sites in Oracle WebCenter sites 12c.

Hello,

Here is the documentation link which explains how to delete the sites from UI

https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/admin/assembling-content-management-sites.html#GUID-47830…

Usually Shared assets are not deleted when deleting a site

When attempting to delete a site, the Sites UI prompts the following message for confirmation:

"This action will permanently delete assets that belong to the site exclusively. It will delete all site configuration information, including start menus, workflow processes, workflow groups, and tree tabs which are configured solely for this site. It will permanently remove the site. Are you sure that you want to delete this site?"

As confirmed by this message, deleting a site will only delete assets that belong to the site exclusively, and not delete any assets that are shared with other sites.

Thanks,

Sreevalli

Hello Santosh,

Sites will be deleted permanently from Database.
Sites related info and its references will be present in different tables based on its usage and data(assets and asset types). So, with just single table one cannot get all sites related information.

Usually list of sites present in the environment can be found in Publication table.

The documentation link which was provided earlier has the configuration information which is affected by the deletion of a site.

Thanks,

Sreevalli