Load DW Fails Invalid Identifier - Reserved word

Document ID : KB000107525
Last Modified Date : 20/07/2018
Show Technical Document Details
Issue:
Load DWH job failing with error:

Invalid Identifier at:
ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)


Note the lookup ID is INDEX.  
Cause:
The lookup was using the reserved word INDEX.
 
Resolution:
Create a calculated attribute as a string to pull in the existing data from the original attribute and use that attribute in the data warehouse.
Additional Information:
Please reference https://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm

for a complete list of Oracle Reserved Words