Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Empty Cat Files? |
Fri, Aug 22 2008 6:00 AM | Permanent Link |
Peter Thorne | I have just moved to a new PC and upgraded from 1.9 B2 to 1.9 B4 in the process (perhaps not a good idea in hindsight). As a result I seem to
have some databases with cat files that no longer refer to any tables in the database (example attached). Opening a database in edb manger won't display any tables even though the db is pointing at the correct directory. The wierd thing is that this has only happened for some of my databases and not all. How can I rebuild cat files for each affected db? Simply deleting the affected file just results in another "empty" cat file. PS - Before you ask I rather dumbly did this operation with a sync programme so I don't have the original cat files ... |
Fri, Aug 22 2008 12:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< I have just moved to a new PC and upgraded from 1.9 B2 to 1.9 B4 in the process (perhaps not a good idea in hindsight). As a result I seem to have some databases with cat files that no longer refer to any tables in the database (example attached). Opening a database in edb manger won't display any tables even though the db is pointing at the correct directory. The wierd thing is that this has only happened for some of my databases and not all. How can I rebuild cat files for each affected db? Simply deleting the affected file just results in another "empty" cat file. PS - Before you ask I rather dumbly did this operation with a sync programme so I don't have the original cat files ... >> I'm afraid there's nothing you can do to recover a catalog file short of re-issuing all of the DDL to create the database objects. The catalog file is the one and only place where all of the metadata for a database is stored. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Aug 23 2008 9:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Peter
>I'm afraid there's nothing you can do to recover a catalog file short of >re-issuing all of the DDL to create the database objects. The catalog file >is the one and only place where all of the metadata for a database is >stored. Unless, it suddenly hit me, you'd reverse engineered it at some point and still have a copy of the generated SQL around? Roy Lambert [Team Elevate] |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |