Re: cannot open segment 1 of relation...

On Tue, 15 Oct 2002 15:39:22 -0400, Rick Eicher II wrote:

> I have started getting cannot open segment 1 of table name errors. This
> problem seems to come and go.
>
> What causes these errors and how so I fix them?
>


Don't know what causes it, but our recent troubles with this error were
cleared up (at least for now!  Knock, knock!) by doing:

REINDEX TABLE tablename;
VACUUM FULL tablename;

--
Jeff Boes                                      vox 616.226.9550 ext 24
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise