Oracle Error Message
ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified
Reason for the Error
RECOVERABLE was specified more than once, UNRECOVERABLE was specified more than once, or both RECOVERABLE and UNRECOVERABLE were specified in a CREATE TABLE or CREATE INDEX or ALTER INDEX REBUILD statement.
Solution
Remove all but one of the RECOVERABLE or UNRECOVERABLE clauses and reissue the statement.