Re: Problem with SS7(WinNT) -> O9i(Solaris) Migration

> Thanks for the input. What puzzles me is that the Oracle model is
> created by the OMWB as I attempt to migrate the model from SS7. Does
> this mean that the tables in the SQL Server database are created that
> way? Do I need to go after our former DBA with a very large axe?

It's been a while since I've used the OMWB, and honestly, I don't want to take the trouble to download it again and install it. But I seem to recall that you could save your DDL as a script, or at the very least, make modifications before you have the OMWB create the Oracle tables for you. Isn't that right? If so, then make sure that the tables in question are not created with the NOT NULL constraint. Although it would probably be a better idea to figure out which column and which rows of which table are giving you fits and resolve the issue. If the NOT NULL constraint is truly needed to enforce your business rules, then dropping it won't be a good idea.

And try to keep axes away from DBAs..........it hurts my profession.....

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"