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.
you just need to explicitly specify the columns you want to popluate in the _STL table.
Map the four columns in the SELECT with the columns in _STL table:
I will assume they have the same column names,
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.