Oracle Database 11G R2 表空间管理
SQL> alter database datafile '/u01/app/oracle/oradata/king/sysaux01.dbf' resize 2048M;
Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/system01.dbf' resize 2048M; Database altered. SQL> alter database tempfile '/u01/app/oracle/oradata/king/temp01.dbf' resize 2048M; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/undotbs01.dbf' resize 2048M; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/users01.dbf' resize 2048M; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/sysaux01.dbf' autoextend off; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/system01.dbf' autoextend off; Database altered. SQL> alter database tempfile '/u01/app/oracle/oradata/king/temp01.dbf' autoextend off; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/undotbs01.dbf' autoextend off; Database altered. SQL> alter database datafile '/u01/app/oracle/oradata/king/users01.dbf' autoextend off; Database altered. 创建表空间 SQL> create tablespace tpcc datafile '/u01/app/oracle/oradata/king/tpcc01.dbf' size 1024M extent management local uniform size 1M; Tablespace created. 增加表空间数据文件 SQL> alter tablespace tpcc add datafile '/u01/app/oracle/oradata/king/tpcc02.dbf' size 1024M; Tablespace altered. 移动表空间数据文件 SQL> alter tablespace tpcc01 offline;?? Tablespace altered. SQL> host cp /u01/app/oracle/oradata/king/tpcc02.dbf /u02/app/oracle/oradata/king SQL> alter tablespace tpcc01 rename datafile '/u01/app/oracle/oradata/king/tpcc02.dbf' to '/u02/app/oracle/oradata/king/tpcc02.dbf'; Tablespace altered. SQL> alter tablespace tpcc01 online; Tablespace altered. SQL> host rm -rf /u01/app/oracle/oradata/king/tpcc02.dbf 删除表空间 SQL> drop tablespace tpcc01 including contents and datafiles; Tablespace dropped. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |