>This is a database of 379 tables, 212 views, 96 relations - impossible to work this in MODI DATA .
Are there any backups? Even if old, can you rename the production DBC, overwrite with the backup, and REINDEX or similar?
ISTR there used to be GenDBC/GenDBCX tools which you could run against a backup, might help with restoring your production one.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up