摘录


After dropping the user, you need to, for each related tablespace, take it offline and drop it. For example if you had a user named 'SAMPLE' and two tablespaces called 'SAMPLE' and 'SAMPLE_INDEX', then you'd need to do the following:

DROP USER SAMPLE CASCADE; ALTER TABLESPACE SAMPLE OFFLINE; DROP TABLESPACE SAMPLE INCLUDING CONTENTS; ALTER TABLESPACE SAMPLE_INDEX OFFLINE; DROP TABLESPACE SAMPLE_INDEX INCLUDING CONTENTS;

点评

但是硬盘上的文件还在?手动删除?

原文

点击这里查看原文

其它

本帖内容由21QA云收藏工具自动生成,欢迎使用。

系统消息 若觉得内容不错,请点击左上角的"赞"图标,以优化网站的内容呈现。 另外,请及时验证注册邮箱,否则收不到21QA发出的红包。 官方Q群:250203055

asked 05 Jul '16, 21:57

%E8%B7%AF%E4%BA%BA%E7%94%B2's gravatar image

路人甲
131528584620


drop user ...... cascade will drop a user and all its objects.

It won't touch any other user's objects in the same tablespace.

If you drop tablespace wit including contents it will drop all objects in that tablespace.

and if you do 
DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES;
This will drop the tablespace, all objects in it and all datafile behind it.
系统消息 若觉得内容不错,请点击左上角的"赞"图标,以优化网站的内容呈现。 另外,请及时验证注册邮箱,否则收不到21QA发出的红包。 官方Q群:250203055
permanent link

answered 05 Jul '16, 21:59

%E8%B7%AF%E4%BA%BA%E7%94%B2's gravatar image

路人甲
131528584620

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×747
×16

question asked: 05 Jul '16, 21:57

question was seen: 1,070 times

last updated: 05 Jul '16, 21:59

powered by O*S*Q*A

粤ICP备14040061号-1