Database Administration (MOSC)

MOSC Banner

Extract Index DLL when it corrupted ?

edited Oct 14, 2011 5:58AM in Database Administration (MOSC) 3 commentsAnswered ✓
 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 ??

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center