Can Not find table error

From: spebola <spebola_at_swbell.net>
Date: 17 Jun 2003 09:27:21 -0700
Message-ID: <b87c466c.0306170827.66d4e6e7@posting.google.com>

I created a table via the OEM using SQL Plus Worksheet and the vb.Net 2003 program can not find it. I receive error message ORA-00942 (cannot find table or view). The script I used to create the table is:

create table Cont

(CN_ContNo         NUMBER(6) NOT NULL,
 CN_AMYM           Char(8) NOT NULL,
 CN_CompCode       Char(5) NOT NULL,
 CN_OfficeCode     Char(5) NOT NULL,
 CN_CustCode       Char(5) NOT NULL,

.
.
.

 CN_Verify CHAR(1) NOT NULL,
constraint Cont_PK PRIMARY KEY (CN_ContNo, CN_AMYM) );

I connected to the sid using a user name with create table and index privileges

The default Tablespace is users.

The table created successfully.

The vb program opens the connection and I am using a data adapter to fill a data set with the schema. I get the error message while executing the data set fillschema command.

I am using Oracle 9i, release 2, Personal Edition.

Any ideas on where to look would be appreciated. I am a new Oracle user (2 days). Received on Tue Jun 17 2003 - 11:27:21 CDT