shrink a segment

简介: 沾一篇来自metalink的好文     Oracle 10g Segment shrink =========================Mandatory=========Init.
沾一篇来自metalink的好文

 

 


Oracle 10g Segment shrink
=========================

Mandatory
=========
Init.ora parameter 'Compatible' must be >=10.0

Shrink operations can be performed only on segments in locally managed
tablespaces with automatic segment space management (ASSM).


How it works
============

1. Enable row movement for the table.
SQL>  ALTER TABLE scott.emp ENABLE ROW MOVEMENT;

2. Shrink table but don't want to shrink HWM (High Water Mark).
SQL>  ALTER TABLE scott.emp SHRINK SPACE COMPACT;

3. Shrink table and HWM too.
SQL>  ALTER TABLE scott.emp SHRINK SPACE;

4. Shrink table and all dependent index too.
SQL>  ALTER TABLE scott.emp SHRINK SPACE CASCADE;

5. Shrink table under MView.
SQL>  ALTER TABLE
阅读(1931) | 评论(0) | 转发(0) |
给主人留下些什么吧~~
评论热议
请登录后评论。

登录 注册

相关文章
|
9月前
|
存储 iOS开发
浅谈block
浅谈block
29 0
|
存储 SQL 负载均衡
Oracle-HWM(High Water Mark) 高水位解读
Oracle-HWM(High Water Mark) 高水位解读
108 0
|
存储 缓存 自然语言处理
|
存储 编译器 iOS开发
Block 详解
原文链接:www.imlifengfeng.com 一、概述 闭包 = 一个函数「或指向函数的指针」+ 该函数执行的外部的上下文变量「也就是自由变量」;Block 是 Objective-C 对于闭包的实现。
950 0