All Oracle Error CodesOracle DBA Forum

ORA-01491:

CASCADE option not valid
Cause: The CASCADE option is only valid for tables or clusters.
Action: Do not specify CASCADE