How do you delete a bunch of spaces through SQL

[slickshow]

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 to get rid of it through the web client or even through SQL?

Thanks.

[kevinr]

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

[slickshow]

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.