Karen, I have seen that error -- several times, actually, in the same database -- but in my case a LIST CONSTRAINTS showed Primary Key where it should have said Primary Key Referenced. I haven't seen it for a long time. That database has been healthy for many months.
In my case I dropped all of the relevant foreign keys and primary keys and created them again. However, more than once, when I did that, the rows in the FK table disappeared, so do backup or unload data for table before you try to correct. Bill On Wed, May 2, 2012 at 12:47 PM, <[email protected]> wrote: > We used "unload all" to recreate the database for a recent upgrade from > 7.6 to 9.1 64-bit. An autochk on the database gives us 6 instances of an > error "A foreign key references a table not known to be referenced" on > various tables. > > First I used some existing code I had to create a cursor thru all FK > columns and write out what PK column/table it references per the > sys_indexes table, and also displayed the "referenced" flag of that PK. > Everything looks great. > > So then I did an "unload schema" and looked at the bottom at all the FKs > (luckily only 25 of them) and all of them reference good tables & columns. > If I list each PK table, each one shows "PK referenced". > > Anyone have a clue what that message means and how I can find out what the > offending entries are? If we reload the database, the reloaded copy > shows the same errors. > > Karen > >
