help for unknown oracle database

Hallo,

following problem:
I have access to an unknown oracle 8.1.7 database. now I want to know and view the tables. how can I do it without having any further information?

thanks, Oliver

PS:
I have already done the following:

> select table_name,owner from dba_tables where table_name like 'EXTERNAL_ID%';

hence:

TABLE_NAME                     OWNER
------------------------------ ------------------------------
EXTERNAL_ID_INFO               PP_SF3
EXTERNAL_ID_INFO               PP_SF6
EXTERNAL_ID_INFO               PP_SF8
EXTERNAL_ID_INFO               PP_TEST
EXTERNAL_ID_INFO               DBFA
EXTERNAL_ID_INFO               PP_SF1
EXTERNAL_ID_INFO               PP_SF4
EXTERNAL_ID_INFO               PP_SF2
EXTERNAL_ID_INFO               DBRB
EXTERNAL_ID_INFO               PP_SF5
EXTERNAL_ID_INFO               PP_SF7

11 rows selected.

now I have tried to access a table with

> describe EXTERNAL_ID_INFO;

ERROR:
ORA-04043: object EXTERNAL_ID_INFO does not exist

or with:

> describe DBFA.EXTERNAL_ID_INFO;

ERROR:
ORA-04043: object DBFA.EXTERNAL_ID_INFO does not exist

what did I do wrong?
how do you get the right scheme? (??.EXTERNAL_ID_INFO) you see, I am an database beginner, so I really need help. thanks again. Received on Fri Jul 05 2002 - 02:25:15 CDT