Gaëtan GUYODO wrote:
OK, it seems to be very easy... When xwiki creates a new schema, there's also a user (with the same name) created into the database. To delete the schema, the only way is to delete the oracle user. Exemple : My main wiki is "xwiki" with Oracle usere "xwiki" and oracle schema "xwiki". I create a new wiki called "wikitest", that will crzate a schema "wikitest" and an oracle user "wikitest". To delete that schema, I have to delete the user "wikitest" using the query :
drop user wikitest cascade constraints
However, I want to realise some tests before you change anything, just to be sure that there's no problem with that solution, and I hav no time today... I'll tell you next week, monday I think.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements0... says that indeed a user owns a single schema, so that is true. -- Sergiu Dumitriu http://purl.org/net/sergiu/