Posted on behalf of an Exor user.
Error message appears when trying to run the Inventory Loader stage 2:
oracle error: ora-00942: table or view does not exist
occured in: dl_lo_3_drop
It seems that the hhinv_load_3 table is missing so you need to create one and restart the load from stage 1.
Please run the following query in SQL*Plus or SQL Developer when logged on as a user doing the load to create a table:
create table hhinv_load_3 as (select * from hhinv_load_2 where 1>1);
Once the table is created you should run the cleaninv script (or maiclinv if run through Exor FasPath) and restart the load from stage 1.
Let me know if you are not familiar with cleaninv and do not have maiclinv installed and I will send it through to you.
Answer Verified By: Sarah Willis-Culpitt
A sql desc of hhinv_load_3 suggests its already there - albeit with 0 rows
Did you do the SQL describe as the user that was trying to load? Each user has their own hhinv_load_3.
Yes, double checked, and confirm used the user trying to do the load
Hi Caroline,
Please run the following query and let me see the results:
select table_name from user_tables where table_name like 'HHINV%';
select table_name from user_tables
where table_name like 'HHINV%';
Also check if the following tables exist by doing:
desc ukpms_t1_survey_types;desc ukpms_view_definitions;
desc ukpms_t1_survey_types;
desc ukpms_view_definitions;
Have you tried to load the same file as a highways owner user?