By Lionel Dubreuil-Oracle on Feb 16, 2012
The Foundation Pack XREF Migration Utility is a tool to perform a one-time migration of cross reference (XREF) data from the existing single XREF_DATA table to new multi-tables, which may yield performance benefits for customers with large XREF tables.
If you work with large XREF tables, splitting up the single XREF_DATA table into one table per XREF artifact improves cross reference lookup performance. The XREF Migration Utility updates the metadata in the XREF artifacts for this multi-table use case, as well as generates a set of scripts that create a new table for each artifact and migrate the corresponding XREF data to them.
For more information, please look at the "Foundation Pack XREF Migration Utility" page on Oracle Technology Network (OTN).