Re: Any help?

Posted in 1997

"Billy Wheeler" — 30 Jan 1997 06:13:13 -0500 — source: Informix-list mailing list archive (1991-1998)

On 29 Jan 97 at 3:46, Joseph Kormann wrote: > >From the restore, we overwrote the systables (they were messed too) > >in the > process removing controls to a table that we kinda need back. If > there's no record (in the systables) of the table, how can we > recreate the table? Create a table with an identical structure, including the indexes. Copy your old .dat and .idx files over your new .dat and .idx files. Run update statistics and bcheck -y the data files. Pray like crazy! :-) HTH. -- Ciao, Billy "...nod's as good as a wink to a blind bat..."