Re: How can I speed up the 'drop index' command?

---- you wrote: > I'm copying tables from one disk to another (faster disks, extent > consolidation). I rename the old tables to keep them around for a few > days until I'm sure the copies are okay. > > I have to create indexes on the new copy using the same names as the > indexes on the old table, so I have to drop the indexes on the old > table first. Some of the tables are > 2Gb in size and have 5+ indexes - > is there any way to speed up dropping the old indexes? Anything I can > change in my onconfig file? Why don't you just rename the old indexes Dude? AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com