Menu
▾
▴
#238 Inconsistent Oracle access
view ID: 3444061.
This applies to Oracle 10.2 and Oracle 9i, connected by oci8 on IIS7.5, both web server and dbms run on windows (the latter on win64).
Anyway, Oracle has its peculiar way to define database objects.
The concept of host is transparent to users, they only see a service and the "host" could be really one or more phisical machines.
The concept of database is more or less equivalent to the service.
The user/schema is really what other dbms call "database".
Adminer has some problems with the dictionary tables. It list tablespaces instead of users, calling them databases; in this case (an idea, I think not a very useful one, imho) a menu with the schema should appear below to choose the user (and the user should automatically be connected to his schema).
There is some recent work on this stuff in the development version at https://github.com/vrana/adminer/. Please take a look at it and send a patch if you are not happy with it.
I don't plan to work on Oracle support myself.
Hello,
may I reopen this issue? Adminer shows a wavering behaviour about Oracle. Some versions honour the peculiar structure of the DBMS, some go back to the low level structure of tablespaces. So tables "disappear" because they are stored in other tablespaces. Why does this happen?
Anyway, after all these years, this issue is still useful.