Use Of DBMS_METADATA.GET_DDL To Extract Index DDL
(Doc ID 438143.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document