All Oracle Error CodesOracle DBA Forum

ORA-01922:

CASCADE must be specified to drop 'string'
Cause: Cascade is required to remove this user from the system. The user own's object which will need to be dropped.
Action: Specify cascade.