SQL 2000 To Oracle 9i Migration Problems

Hi all,



I am using the Oracle Workbench for migrating my DB currently on Sql
Server 2000 to Oracle 9i. During the migration the following happens



SELECT @tBaseTable = tBaseTable, @tDBColumnName = tDBColumnName

FROM tblColumnMain WITH (NOLOCK) left join tblCustomField WITH
(NOLOCK) on aColumnID = nColumnID

WHERE aColumnID = @nPropertyID



gets converted to



SELECT tBaseTable, tDBColumnName

INTO

SPROC_PROPDATA.tBaseTable, SPROC_PROPDATA.tDBColumnName, FROM
sa.tblColumnMain, sa.tblCustomField

WHERE (aColumnID = nColumnID) AND (aColumnID =
SPROC_PROPDATA.nPropertyID_);





and gives the warning that complex outer joins maynot be reliably
converted



On the other hand the following code



select @keyid = a.keyID, @pubs=b.pubs from

ssd1 a left outer join ssd2 b on a.l_name = b.l_name

where b.l_name = @name



migrates perfectly to Oracle as



SELECT a.keyID, b.pubs

INTO SPROC_JOINTEST8.keyid, SPROC_JOINTEST8.pubs

FROM ssdash.ssd1 a, ssdash.ssd2 b

WHERE (a.l_name = b.l_name(+)) AND

(b.l_name = SPROC_JOINTEST8.name);



with the same warning ...



Could anyone enlighten me as to what exactly is the difference between
these 2 above cases.



Also the migration bench seems to be removing nolocks and such stuff all
around. Any workaround for this is also needed.



ssDash


--
Posted via http://dbforums.com