Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Not find table error

Re: Can Not find table error

From: spebola <spebola_at_swbell.net>
Date: 18 Jun 2003 19:36:18 -0700
Message-ID: <b87c466c.0306181836.38163dcd@posting.google.com>


>
> Hmm.. illogical captain ...
>
> when you do your select from user_objects, does the name of your table
> appear in upper case? And is the object_type listed as table?

I finally discovered the problem. When I connected to the database to create the table I was connecting as SYSDBA. When I connected as NORMAL and created the table everthing worked.

Jeremy, Thanks for your comments and your time, I really appreciate it. Received on Wed Jun 18 2003 - 21:36:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US