FDM IMport Error
Hi All,
Getting the following error during import.Integration script to Oracle DB/View to import data.
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... ORA-00972: identifier is too long
CREATE BITMAP INDEX IX_tWepmadm101690810170046859_BA ON tWepmadm101690810170046859 (CalcAcctType) TABLESPACE USERS COMPUTE STATISTICS
ERROR:
Code............................................. -2147217900
Description...................................... ORA-00972: identifier is too long
CREATE INDEX IX_tWepmadm101882410188285850_1 ON tWepmadm101882410188285850 (ACCOUNT) TABLESPACE USERS COMPUTE STATISTICS
The issue seems to be caused bez the index name cannot be more than 30 characters and some how FDM seems to create this index.In the configuration setting tried changing the bitmap switch to ON and OFF but did not make any difference.