While trying to migrate a schematic dataset from 9.3 to 10.2 I am facing the following error:
ORA-00972: identifier is too long
After looking through the dataset I found the offending element which had the name PCD_STRUCTURE_CONTAINER, I noticed that the table names related to this element are truncated (due to the oracle identifier length restriction) to something like sch321e_pcd_structure_c.
How would I go by fixing this in order to be able to migrate the dataset to 10.2 since I can't rename the existing schematic element?
Also, where can I get detailed logs of the ArcCatalog schematic migration process since the error provided through the user interface was not enough for me to find out the problem without digging into the tables and figuring out which one was the one with the offending identifier name.