b1nary0mega
5/3/2016 - 12:47 PM

Create the output to rebuild all index for the 'medsched' schema

Create the output to rebuild all index for the 'medsched' schema

SELECT * FROM dba_indexes WHERE owner=upper('medsched');

SELECT 'alter index '
  ||owner
  ||'.'
  ||index_name
  ||' rebuild online nologging;'
FROM dba_indexes
WHERE owner=upper('medsched');