topic Re: How do you delete a bunch of spaces through SQL in Alfresco Archive

How do you delete a bunch of spaces through SQL

slickshow — Tue, 07 Aug 2007 19:35:31 GMT

I run Alfresco on Oracle 10g. When I (mis)configured LDAP, it imported a whole bunch of users. I reconfigured it so that it deleted all the users during a fresh sync, however it did not delete their home spaces under Company Home. There are over a 1000 spaces that I dont need. Is there a quick way t

Re: How do you delete a bunch of spaces through SQL

kevinr — Mon, 13 Aug 2007 14:30:47 GMT

In the web-client the Delete action on a Folder gives you choices of delete all contents etc. but they may delete more than you want? Another way is to log into via CIFS or FTP as admin user and select the dirs you want in a decent CIFS/FTP client.

Thanks,

Kevin

Re: How do you delete a bunch of spaces through SQL

slickshow — Mon, 13 Aug 2007 18:08:01 GMT

Unfortunately all the spaces that were created are under CompanyHome, so therefore I dont want to delete the contents at that level. In the current setup we have, we've disabled CIFS (due to security issues), so thats not an option either. I'll give the FTP option a try.

Thanks.