Karen
What I have done in the past was this
Make sure messages and error messages on are
OUT whatever.ALL
UNLOAD ALL
OUT TERM
In the whatever.all file I cut out all of the create views, create
index and alter table
I put each one of them in their own file.
RENAME the old database
Now using 9.1(64)
Run whatever.all
If this is really big database I would make a copy of it at this
time.
Run the create views file
Run the create index file
Since you are having problems with constraints I would
Trace the alter table file. It should stop on the error.
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Wednesday, May 02, 2012 12:47 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Constraint troubleshooting?
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
