Re: Foreign Keys in *.SQL File
I went through the SQL Command and found the source of the problem. It seems to have been a small bug.
One of the foreign keys was displayed correctly in the workbench. But in the interpretor it didn't get written. I deleted the foreign key and recreated it exactly as before and it worked perfectly.
I can't reproduce but it involved:
Adding Foreign Key.
Renaming Table
Exporting SQL File.
The syntax was something like FOREIGN KEY ('') REFERENCES ''.('') even though the workbench version had entries.
Oh one bug I *can* reproduce:
If I zoom out past the pages in either the OpenGL or software version the viewport goes crazy and is unusable until you zoom in to 100% or closer.
Edited 2 time(s). Last edit at 02/11/2008 10:24PM by gavin Greenwalt.
Subject
Views
Written By
Posted
3609
February 11, 2008 08:38PM
Re: Foreign Keys in *.SQL File
2382
February 11, 2008 10:20PM
2323
February 12, 2008 04:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.