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