Oracle issue(simple maybe)

[Dean Johns]

Issue,

� I have installed Oracle XE 10g edition a few months back in windows XP

� On top of that, I installed oracle 9i.

� Installation was fine; I could create a master database and a user under it. so my application can be connected to oracle using the newly created user.

� Now I could not create tablespace. I have logged in with that user credentials, i have given DBA, CONNECT, RESOURCE privileges to that user.

� I uninstalled Oracle XE 10g.

� Uninstalled Oracle 9i. Re-Installed oracle 9i

� Still Installation was fine; I could create a master database and a user under it .so my application can be connected to oracle using the newly created user.

� I could not create tablespace. I have logged in with that user credentials, i have given DBA, CONNECT, RESOURCE privileges to that user. (My application creates tablespace)


Please let me know if you knows solution or reason.

Thanks
[ September 14, 2007: Message edited by: Dean Johns ]

[Agador Paloi]

XE and 9I do step on each others toes. I am developing a swing app that uses 10G XE and also have some 9i client applications to support. so far
I have not had them run on the same machine, although I haven't spent much time on it . In the past I was able to run Oracle Lite and 9i client
to run on the same machine by changing TNSNames .

another thing to beware of is that Oracle uninstall does not clean up the registry after itself. you need to do that.