I have a large number of documents stored in XML DB, about 50 GB. Now I need to move them to a new Oracle database 11.2. The documents to be moved are in its own folder structure. We also uses ACL files to manage privilege. My question is - what is the proper way to move XML DB resources between two databases. For example, a test and production environment?
Any help / insight into this problem would be deeply appreciated.