Re: compile index error

Posted by ErmanArslansOracleBlog on Oct 13, 2016; 5:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/compile-index-error-tp1395p1399.html

It s just a dynamic sql. It will return the statements that you need to execute. That is , you ll execute the output of that query.

13 Eki 2016 20:23 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Is the query ok?

select 'ALTER INDEX ' || index_owner || '.' || index_name || ' REBUILD SUBPARTITION ' ||
subpartition_name || ';'from dba_ind_subpartitions where index_name in (select index_name from dba_indexes where status='N/A');

I started executing it.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/compile-index-error-tp1395p1398.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML