Use Of DBMS_METADATA.GET_DDL To Extract Index DDL
Last updated on DECEMBER 13, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Oct-2017***
Suppose dbverify or normal operations threw numerous ORA-12700 or ORA-1578 or ORA-1499 errors in alert log indicated a whole index tablespace was corrupted.
While dropping and creating the tablespace is simple, getting the syntax needed to recreate the index is a bit more complicated.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms