DBA Missing Error Message
DBA Missing Error Message
One of my client getting DBA files are missing error in his database. This is only happening on few tables. And when he reorganize the database.
Question is, is there an easy way to fix this via RDRR edit?
Re:DBA Missing Error Message
This basically means that the .TDF is missing. Message is just so old that it say .DBA.
in 8.2 you can delete a table even when the table is missing, so simply go to Tables in Catalog and delete the "offensive" tables.
You will get a lot of error messages, but the entry will be deleted.
Sometimes you can't see the change in the catalog, so close it and re-open it to make sure they are gone.
Re:Re:DBA Missing Error Message
After working with my client, this is fixed now. All of these message came out of TEMP tables.
Once we deleted those tables, everything is good.
Re:Re:Re:DBA Missing Error Message
It is normally temp tables that has been created in RDRR but where the .TDF/.DBM has successfully been removed, so simply to delete them in the Table View of the Catalogue will almost always be successful.