With regard to your first question, I don't know why you would expect to WebSphere to "pick up" Oracle automatically. You need to do some configuration. WebSphere is only set up to work with DB2 by default.
With regard to the second, "SELECT * from TAB" shows you only the user's (SCOTT) schema. (This is equivalent to "SELECT TABLE_NAME FROM USER_TABLES". There are two other, more comprehensive, views: SELECT TABLE_NAME FROM ALL_TABLES; and SELECT TABLE_NAME FROM DBA_TABLES; (You need to be logged in with DBA privileges for the last one.) Good luck! - David Gallardo At 01:28 PM 9/19/2002 -0500, Saikat Goswami wrote: >Hi All, > >I have installed Oracle 8i, and have IBM WebSphere 4.o trial version. I am >trying to run the sample petstore application. There are a few issues that I >am facing: > >(1) WebSphere is not picking up Oracle database automatically ( I can see >this from the Administrator's Console). >(2) I do "SELECT * FROM TAB" in Oracle, and I see only 5 basic tables. What >do I need to do in order to load the system tables? I logged in as the usual >"scott". > >Any help is appreciated. > >Thanks, >Sai > >To change your JDJList options, please visit: >http://www.sys-con.com/java/list.cfm To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm
