plsql - Creating table in Oracle then inserting multiple fors with select -

I'm experimenting with Oracle 11G Todd 10.6. And many secondary tables (which I did not), who joined the rest of the code - I rows to select a statement that the first record of the primary table shown below (the product) will pull insert table I'm trying to make, results filtering

  table making Mjhottemp (Customer ID number (10), CanvCD varchar2 (6), CanvISS number (3)); COMMIT; MJHOTTEMP (Customer ID, canvcd, insert canviss) As DISTINCT r.CUSTOMER_ID select Customer ID, r.CANVASS_CODE as canvcd, r.CANVASS_ISSUE_NUM core.product R  as canviss 

< p> when I run, I "enter MJHOTTEMP is get an error at line"

  ORA-00942: table or view does not exist  

< P> See the table in schema. Any idea why this does not work?

"itemprop =" text ">

This is usually a permissions error. Verify that the user you are connecting to is selected on core.product table (at least)

GRANT selected for core.product 'your_user' ;.

I'm assuming you are choosing custom user can not use functions or other users of proprietary ideas or processes. In this case you may need to select the product at

  core. Products on 'your_user' with reference;