Re: help for unknown oracle database

Oliver Brausch wrote:

> 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.

Based on what you have written it is impossible.

At minimum you would need a user-id, password, the server on which it is hosted, and the instance name.

Daniel Morgan Received on Fri Jul 05 2002 - 11:19:05 CDT