How to delete oracle user and table space

In Oracle, you can use the "drop user user name cascade;" command to delete the specified user, and you can use the "DROP TABLESPACE table space name INCLUDING CONTENTS AND DATAFILES;" command to delete the specified table space.

The operating environment of this tutorial: Windows 7 system, Oracle 11g version, Dell G3 computer.

How to delete oracle users and table spaces

Delete users

drop user 用户名称 cascade;

Delete table space

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

Delete empty table space, does not contain physical files

DROP TABLESPACE tablespace_name;

Delete empty table space, contains physical files

DROP TABLESPACE tablespace_name INCLUDING DATAFILES;

Delete non-empty tablespace, does not contain physical files

DROP TABLESPACE tablespace_name INCLUDING DATAFILES;

Delete non-empty tablespace, contains physical files

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to delete oracle user and table space. For more information, please follow other related articles on the PHP Chinese website!