alter tablespace/database语句中的reuse选项

最新推荐文章于 2024-07-08 11:20:31 发布

haiross

最新推荐文章于 2024-07-08 11:20:31 发布

阅读量4.2k

点赞数

分类专栏： oracle开发SQL语句数据库间的数据迁移 oracle备份与恢复 oracle疑问集

本文链接：https://blog.csdn.net/haiross/article/details/18559753

版权

274 篇文章 13 订阅

订阅专栏

81 篇文章 1 订阅

订阅专栏

33 篇文章 0 订阅

订阅专栏

例子：

alter tablespace temp add tempflie ‘d:\temp1.dbf’ size 100m reuse：

说明：

The way the database interprets filename also depends on whether you specify it with theSIZE andREUSE clauses.

If you specify filename only, or with theREUSE clause but without theSIZE clause, then the file mustalready exist.
If you specify filename withSIZE but withoutREUSE, then the file must be a new file.
If you specify filename with bothSIZE andREUSE, then the file can be either new or existing. If the file exists, then it is reused with the new size. If it does not exist, then the database ignores theREUSE keyword and creates a new file of the specified size.