Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help for a baffled beginner

744247Jan 4 2010 — edited Jan 4 2010
Ive just installed Oracle Express to help me go through a phase test. Ive created 3 tables under the SYSTEM username that I started the database with. Ive populated the tables with some data

Now whenever I try and enter any SELECT command it tells me

ORA-00942: table or view does not exist

Now a quick look on google tells me this is most likley that I don't have permission...however, I can't see what I can do to change that, I am the only user. If I create a new admin and recreate the tables it tells me the same.

Also, infuriatingly, it tells me that the 'show tables' is not a valid SQL command so I cannot make sure I am typing it correctly. Although obviously I have gone back into the object browser to check countless times.

Please help me out! Im assuming its something small, but google is huge and I don't even know where to begin with this.

Thanks
Mike
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2010
Added on Jan 4 2010
15 comments
1,311 views