We have been working on a migration from MSSQL7 on Windows 2000 to 10g
on Windows 2003 and are almost ready to go. I have been using the
Migration Workbench for several months now with only a few issues with
Text to CLOB conversions. I found a work around using SQL*Loader
scripts. However, for the last week I am having an issue with the
Generate SQL*Loader scripts not creating the Create_View.sql for the
data extract portion. For example I select 8 tables from the Oracle
Model, right click and select generate scripts. When I look at the
results the batch files are okay, and the ctl files are okay for all 8
tables. The Create_View.sql and Drop_View.sql scripts have been
generate but all of the tables are not present in them, 3 are missing.
I tried again selecting just 1 of the missing tables and once again the
batch and ctl files are fine, the Create_View.sql and Drop_View.sql
scripts have been created but they are empty. While investigating this
problem last week I found that a new version of the Migration Workbench
had been released, not that it helped, the same issue are present. I
have tried the default, olite, repository and using a full blow Oracle
database, still no help. I have opened a TAR but they are puzzled also.
Has anyone experienced this and found the cause/solution?
Regards,
Charles Deaton
cdeaton_at_corp.realcomp.com
Received on Mon Jan 31 2005 - 13:35:47 CST
