Re: rebuild indexes

> A vendor wants me to shrink a table. I've never shrunk one in oracle. Does
> that delete the data out of them?

Nope. Just frees the empty space:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN01401

> And then wants me to rebuild the associated indexes. Won't they be empty
> after you shrink them?

I would be wary about this operation. The "why" is very important here. If the table's going to grow after the shrink, then there's a chance that performance could suffer after the shrink/rebuild:

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2290062993260

(URL will probably split -- sorry)

Research and benchmarks should help here.

HTH! GL! Rich

--
http://www.freelists.org/webpage/oracle-l