Anyone have any experience using execute immediate? I'm trying to use a procedure to rebuild indexes. Problem is the indexes are SAP flavor with the ~ symbol in them which is giving oracle fits. I've been able to hide the symbol in a normal sqlplus prompt with " ( double quotes ) around the index name, however, execute immediate is not recognizing the index name and not working. The following is what I'm using to no avail.
Execute immediate analyze index ' || owner ||
'."' ||
segment_name ||
'" validate structure'
with owner and segment_name coming from dba_segments.
Thanks in advance
Execute immediate analyze index ' || owner ||
'."' ||
segment_name ||
'" validate structure'
with owner and segment_name coming from dba_segments.
Thanks in advance