For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi,
what is the best way to clean up or remove old sites which we are not going use in Oracle WebCenter Sites 12C.
If we delete the sites, is there any impact on other sites?. Because we have shared many assets with other sites as well.
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
Thank You Sreevalli. Could please let me know the following?.
At DB point of view, is it going to delete soft/hard delete the site and site related info?.
And how can i confirm those details in Db where all the site related info stores.
Thank You,
Santosh Gajjala
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.
Hello Sreevalli,
So if we delete the site, the site will get deleted from Publication table right?. and i more thing, the site related info and the reference also deleted right?. Could please let me know the some tables like CSElement, Template, Blogs where those are available for specific site.
it is very helpful, if you provide the doc which has all the DB information.
Santosh
Yes Sites will be deleted from Publication table. Coming to the tables most of the tables are common for all the sites. For Example CSElements, Templates these tables contain all the templates, cselements created in whole Sites system not specific to one site. But particular site elements will be deleted from those tables if site is deleted.
For more information on Database, Go through the following documentation which might be helpful
https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/admin/webcenter-sites-database-tables.html#GUID-F6723F6A-D4F6-4C2E-AA10-9AB2A4430669
https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/develop/working-webcenter-sites-database.html#GUID-36CD3D68-4F04-4655-A104-BD5E9967931E