Yes, but I just want to make some more tests to bu sure about the query
to use for deleting wiki.
Sergiu Dumitriu a écrit :
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.
--
__________________________________________
Gaëtan GUYODO
Chargé de mission
Centre Antipoison - Hôpital Fernand WIDAL
200, rue du faubourg St Denis
75475 PARIS Cedex 10
Tél: 01 40 05 49 63 / Fax: 01 40 05 48 56
__________________________________________