ORA-01950: no privileges on tablespace "HHINV_LOAD_3_SPACE"


 Product(s):Exor Maintenance Manager
 Version(s):04.07.00.05
 Environment:N\A
 Area:Loaders - Inventory
 Subarea:N\A

Error or Warning Message

ORA-01950: no privileges on tablespace "HHINV_LOAD_3_SPACE"

Explanation

This can happen during the loader stage 2, especially if you've had errors about table hhinv_load_3 not existing.

How to Resolve

  1. Log onto SQL*Plus as the Highways owner
  2. Run the following command, replacing <username> with the username of the person trying to do the load: SQL> alter user <username> quota unlimited on hhinv_load_3_space;
  3. Use fastpath as the person trying to do the load and run module MAICLINV