Hello and Thanks for Reading
Made a ton of changes to the model, ran generate change script, applied it to the database, got errors (This is a first).
As I'm in design mode (no actual data yet) I took the database offline, deleted the data files, recreated the schema/file groups, ran generate DDL in Toad, ran it, no errors.
Then just to make sure I was in sync, I ran generate change script. To my surprise it generated a rather large script. So I ran it against the database. No errors.
Ran generate change script again. This time several tables were not selected in the first dialog. As I want to compare everything, I checked them. Again a large script.
I'm really not sure what's going on here. I suppose I could delete the model and reverse engineer the database but then my beautiful ERD diagram I spent hours making all the lines pretty would have to be done over.
I'm probably doing something stupid, any ideas?