Hey Brian, > 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 -- //www.freelists.org/webpage/oracle-l
