title: Oracle drop and create index
body: <p>I would like to know if dropping Oracle index and recreating them will pose any data issues if assuming these are done during scheduled downtime. </p>
  
  <p>Recently discovered that some indexes were parked on incorrect table space, would like to correct it by dropping the index and recreating it on the correct table space. </p>
  
  <p>Please kindly advise.</p>