Cause
parameter which supplies partition name is missing. This parameter is optional for non-partitioned objects, but is required for partitioned objects.
parameter which supplies partition name is missing. This parameter is optional for non-partitioned objects, but is required for partitioned objects.
Remove offending clause. [UN]RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/3229900
Browse all solutions to database errors from Oracle, MS SQL, or MySQL