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/，如需转载，请注明出处，否则将追究法律责任。