Purpose
To ensure the Migration Engineers are aware that the comments for 'CREATE INDEX' are incorrect and need to be reformatted.
Scope & Application
The audience for this document is Oracle Customers, Oracle Partners and Oracle Migration Specialists using the Oracle Migration Workbench to perform SQL Server or Sybase Migrations
Create Index On Temp Tables
A comment is left in the procedure where an index was created on a temp table.
This comment is in an incorrect format. It should be changed to:
Before After
NULL;
/*[SPCONV-ERR(104)]:CREATE INDEX statement passed to ddl file*/
-- MTG Note: Index <index_name> created
 
This allows Migration Engineers to find all occurances of indexes on temp tables and decide whether the index should be disabled for the data move or not.
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy