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. 在回滚表空间在使用或者还有事务的 时 ， 不能被删除
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-972698/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002887
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
