ORA-00942 table or view does not exist
Posted on 2004-10-14
When I run this statement using SQL*Plus Worksheet
INSERT INTO Rd.FIELD_DEVICE_DEFN_STL
I get this error
INSERT INTO "Richmond"."FIELD_DEVICE_DEFN_STL"
ERROR at line 1:
ORA-00942: table or view does not exist
The asterisk is directly under the double quote before FIELD_DEVICE_DEFN_STL
I created the table Rd.FIELD_DEVICE_DEFN_STL from Rd.FIELD_DEVICE_DEFN by using Create Like in Enterprise Manager.
The select statement returns the rows that I want to insert into the other table. I am only inserting about half of the columns from Rd.FIELD_DEVICE_DEFN into Rd.FIELD_DEVICE_DEFN_STL.
Based on some stuff I read here I granted a couple of privileges to this table to the user.
I have very little Oracle experience, so I use OEM to make changes.