Thanks for the quick response.

We would rather not shrink the file, as you said, all indexes would have to be rebuilt.

This is an older system, 32 bit Windows.

The reason we were considering it is the disk it is on will be filled up in the near future.

autoextend is set to 10%. We could reduce this so the file does not grow.

One other question, at what point does the datafile extend. Is there a way to see at what percent

the file usage gets to when it extends.

Keith