Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Secondary index |
Fri, May 8 2009 9:17 AM | Permanent Link |
Larry | can DBSYS.EXE be used to repair the secondary indexes?
I have a file that has lost its 3 secondary indexes, primary is Ok and idx file is present. The file has data so do not want to just repalce it urgent Thanks LArry |
Fri, May 8 2009 9:44 AM | Permanent Link |
"Robert" | "Larry" <larry@vikingcomp.co.za> wrote in message news:05DF75F8-FF9A-4C45-AAF0-767131A9DF0E@news.elevatesoft.com... > can DBSYS.EXE be used to repair the secondary indexes? > > I have a file that has lost its 3 secondary indexes, primary is Ok and idx > file is present. > > The file has data so do not want to just repalce it > > urgent > Assuming the data portion is OK (I would at least run a verify and also a query producing some totals that you can check against an external total) all you need to do is re-add the indexes using SQL. Robert |
Mon, May 11 2009 4:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Larry,
<< can DBSYS.EXE be used to repair the secondary indexes? I have a file that has lost its 3 secondary indexes, primary is Ok and idx file is present. >> A repair cannot re-add any missing indexes, but it can repair the table, including all indexes that are present. If you know what the index definitions are, then I would suggest that you simply re-add them after repairing the table. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, April 19, 2024 at 07:09 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |