Oracle扩容表空间

2、通过google查询，问题是表空间文件不够了

<span style="font-family: 仿宋; font-size: 18px"><span style="color: #0000ff">SELECT</span> a.tablespace_name "表空间名",a.bytes <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> "表空间大小(M)",(a.bytes <span style="color: #808080">-</span> b.bytes) <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> "已使用空间(M)",b.bytes <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> <span style="color: #808080">/</span> <span style="color: #800000; font-weight: bold">1024</span> "空闲空间(M)",<span style="color: #ff00ff">round</span>(((a.bytes <span style="color: #808080">-</span> b.bytes) <span style="color: #808080">/</span> a.bytes) <span style="color: #808080">*</span> <span style="color: #800000; font-weight: bold">100</span>, <span style="color: #800000; font-weight: bold">2</span>) "使用比" <span style="color: #0000ff">FROM</span> (<span style="color: #0000ff">SELECT</span> tablespace_name, <span style="color: #ff00ff">sum</span>(bytes) bytes <span style="color: #0000ff">FROM</span> dba_data_files <span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> tablespace_name) a,(<span style="color: #0000ff">SELECT</span> tablespace_name, <span style="color: #ff00ff">sum</span>(bytes) bytes, <span style="color: #ff00ff">max</span>(bytes) largest <span style="color: #0000ff">FROM</span> dba_free_space <span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> tablespace_name) b <span style="color: #0000ff">WHERE</span> a.tablespace_name <span style="color: #808080">=</span> b.tablespace_name <span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> ((a.bytes <span style="color: #808080">-</span> b.bytes) <span style="color: #808080">/</span> a.bytes) <span style="color: #0000ff">DESC</span>;</span>

3、查看表空间文件位置

<span style="font-family: 仿宋; font-size: 18px"><span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span> dba_data_files <span style="color: #0000ff">WHERE</span> tablespace_name <span style="color: #808080">=</span> <span style="color: #ff0000">‘</span><span style="color: #ff0000">LMSTEST</span><span style="color: #ff0000">‘</span>;</span>

4、增加表空间文件

<span style="font-family: 仿宋; font-size: 18px"><span style="color: #0000ff">alter</span> tablespace LMSTEST <span style="color: #0000ff">add</span> datafile <span style="color: #ff0000">‘</span><span style="color: #ff0000">/home/oracle/data/lmstest.dbf</span><span style="color: #ff0000">‘</span> size 5120M;</span>

Oracle扩容表空间

标签：bubuko   ace   height   where   select   空间名   bsp   inf   add