| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple PO7w95 Navigator/SQL+ question
Most likely, the tables you are attempting to select or describe are not in the schema of the database user.
I'll take a guess (because I haven't installed PO7 myself) that some of the sample tables and views are in the SCOTT schema, hence owned by user SCOTT. If you login to Oracle using the traditional SCOTT/TIGER username and password combination, you should be able to issue the statement:
DESCRIBE EMP; But if you login as a user other than SCOTT, say SYS for example, you will now need to fully qualify the object name. If you issued the above statement, you would get the error message you described below, because although the EMP object exists, it does not exist in the SYS schema. Thus, you would need to issue the following statement:
DESCRIBE SCOTT.EMP; There are other ways to circumvent this problem through the use of database synonyms, but this most likely is the cause of your error.
On Mon, 30 Dec 1996 23:16:46 GMT, Josh_at_vn.com wrote:
>I Loaded a trial version of PO7 for win95, and sure enough, there are
>the sample tables/views/etc...visible from navigator...no problem yet.
>
>Then I go into SQL+ to try a SELECT or a DESC on a table and I get
>"object does not exist" I've tried several tables and several roles
>and no luck.
>
>What stupid little thing am I missing here?
>
>
>Thanks.
Joel
Joel R. Kallman See Oracle technology in action! Oracle Government http://govt.us.oracle.comBethesda, MD
 |
 |