|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
DROP SEQUENCE to ROLLBACK, 9 of 20
USER statement to remove a database user and optionally remove the user's objects.
You must have the
USER system privilege.
Specify the user to be dropped. Oracle does not drop users whose schemas contain objects unless you specify
CASCADE or unless you first explicitly drop the user's objects.
CASCADE to drop all objects in the user's schema before dropping the user. You must specify this clause to drop a user whose schema contains any objects.
CASCADE, the materialized views can no longer be refreshed.
If user Sidney's schema contains no objects, you can drop
sidney by issuing the statement:
If Sidney's schema contains objects, you must use the
CASCADE clause to drop
sidney and the objects: