[xwiki-devs] Import / Export Options - Problems with rights

I think somehow my Group and User rights for Spaces are corrupted. Is there some way to verify a problem in the hibernate tables? I was running Xwiki on a Oracle 9 database which I didn't realize was not supported until reading through the Xwiki Dev maillist. I had many exceptions about clob mapping in the xwiki log even after upgrading to Oracle 10 jdbc driver which should have fixed it. I tried to delete and re-add the Groups but when I re-added the Groups they seemed to already have the rights to the Spaces they had before I deleted them. It seems like the delete Group failed. I want to export xwiki data from Oracle 9 and import it into a new Oracle 10 database. The import would allow me to select specific items to import. So, I tried to use the export Admin function which can successfully export everything but then the import function cannot read anything very large. Even if you increase the maximum upload size , and increase heap size you will still run out of memory on import (my export data was about 45MB). I found jira bugs and mail posts related to this problem. I also encountered: XWIKI-1809 during import. I can use Oracle tools to extract and reload the data but it will reload the same corrupt data that I was trying to fix. I found the xwiki-packager-plugin but it seems to have the same issues as import / export Admin function and seems to be limited to hypersonic db. At least there is a method called shutdownHSQLDB and a comment about needing to figure something out for other databases. Is there some way to validate and fix Xwiki Group / User rights before I extract using oracle? Is there some way to extract a portion of the data stored in the hibernate managed tables? I would like to extract data for each space without any users and groups. I could help on the import / export if it can be fixed but I'm not sure requiring all xwiki data in memory at once can be fixed. Has another approach been discussed? Any suggestions on any of the above issues are welcome. I'd really like to use Xwiki! Thanks Glenn Everitt -- View this message in context: http://www.nabble.com/Import---Export-Options---Problems-with-rights-tp1657… Sent from the XWiki- Dev mailing list archive at Nabble.com.