Oracle in a Nutshell

Name

TABLESPACES

Synopsis

Provides the ability to work with tablespaces.

Unique privileges

MANAGE

Gives the privilege to take tablespaces offline and online and to begin and end tablespace backups.

UNLIMITED TABLESPACE

Gives the privilege to override any specific tablespace quotas assigned. If this privilege is revoked, a user cannot allocate an additional tablespace unless allowed by existing tablespace quotas. This privilege cannot be granted to a role.

Common privileges

CREATE, ALTER, DROP.