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_elements…
says
that indeed a user owns a single schema, so that is true.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/