Extract Index DLL when it corrupted ?
Hi all,
I can create a test case to make corrupt data block for segment type but can't for index type.
Follow MOS 28814.1 , section 4B about recreating index, it's said that:
------------------------------------------------------
CREATE INDEX <index_name> .. with appropriate storage clause
------------------------------------------------------
I can extract index DLL (438143.1) :
------------------------------------------------------
select dbms_metadata.get_ddl('INDEX', 'EMP_EMAIL_UK', 'HR') from dual;
------------------------------------------------------
But if index EMP_EMAIL_UK corrupted, how I can extract DLL such command above ??
0