ITPub博客

首页 > 应用开发 > IT综合 > Creation of Undo Tablespaces (42)

Creation of Undo Tablespaces (42)

原创 IT综合 作者:tsinglee 时间:2007-09-27 18:04:06 0 删除 编辑

A database administrator creates undo tablespaces individually, using the CREATE
UNDO TABLESPACE statement. It can also be created when the database is created,
using the CREATE DATABASE statement. A set of files is assigned to each newly
created undo tablespace. Like regular tablespaces, attributes of undo tablespaces can
be modified with the ALTER TABLESPACE statement and dropped with the DROP
TABLESPACE statement.

An undo tablespace cannot be dropped if it is being used by
any instance or contains any undo information needed to recover
transactions.

1. 可以用create undo tablespace创建
2. 在创建数据库时create database可创建
3. 在回滚表空间在使用或者还有事务的 时 , 不能被删除

[@more@]

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

上一篇: Undo tablespaces (41)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1900604