database
-
编辑 删除
Oracle表空间操作详解-入门基础
==============================Oracle表空间操作详解-入门基础==============================建立表空间CREATE TABLESPACE data01DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500MUNIFORM SIZE 128k; #指定区尺寸为128k,如不指定，区尺寸默认为64k删除表空间DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES; 修改表空间大小alter database datafile '/path/NADDate05.dbf' resize 100M 移动表至另一表空间alter table move tablespace room1; --------------------------------------------------------------------一、建
