oracle建立不同块大小的表空间

实验：

Specifying Nonstandard Block Sizes for Tablespaces
DB_nK_CACHE_SIZE

DB_BLOCK_SIZE

ALTER SYSTEM set DB_CACHE_SIZE = 8M scope=BOTH;
    ALTER SYSTEM set DB_16K_CACHE_SIZE =4M scope=BOTH;
    CREATE TABLESPACE test2 DATAFILE '/home/oracle/app/oracle/oradata/orcl/test02.dbf' SIZE 50M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
    BLOCKSIZE 16K;
    drop tablespace test2;
    --DROP TABLESPACE test2 INCLUDING CONTENTS AND DATAFILES;--这个才是正确的删除姿势
    ALTER DATABASE DATAFILE 8 OFFLINE FOR DROP;--归档模式下offline和offline drop效果是一样的 
SQL> select name,status from V$datafile where FILE#=8;
NAME                                                                             STATUS
-------------------------------------------------------------------------------- -------
/home/oracle/app/oracle/oradata/orcl/test101.dbf                                 RECOVER
--文件还是存在
--物理删除，重启无报错，如果不执行删除数据文件命令，会报错

Oracle 删除数据文件

转载于:https://www.cnblogs.com/Babylon/p/8625509.html