1. 首页
  2. IT资讯

ALTER TABLESPACE

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3002.htm

这个站点可以链接很多技术细节

[@more@]

  • Take the tablespace online or offline

  • Begin or end a backup

  • Make the tablespace read only or read write

Before you can make a tablespace read only, the following conditions must be met:

  • The tablespace must be online.

  • The tablespace must not contain any active rollback segments. For this reason, the SYSTEM tablespace can never be made read only, because it contains the SYSTEM rollback segment. Additionally, because the rollback segments of a read-only tablespace are not accessible, Oracle recommends that you drop the rollback segments before you make a tablespace read only.

  • The tablespace must not be involved in an open backup, because the end of a backup updates the header file of all datafiles in the tablespace.

Performing this function in restricted mode may help you meet these restrictions, because only users with RESTRICTED SESSION system privilege can be logged on.

Syntax

alter_tablespace::=

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027050/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194666.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code