Chapter 3
-----------------------------------------------------
Section 3.4.2 Administering ASM

SET ORACLE_SID=+ASM
sqlplus /nolog
connect sys/password as sysdba
ALTER SYSTEM SET asm_diskstring = '\\.\*:' ;
CREATE DISKGROUP data
     NORMAL REDUNDANCY DISK '\\.\H:', '\\.\I: ' ;


ALTER DISKGROUP data ADD DISK '\\.\J:', '\\.\K: ' ;


CREATE TABLESPACE easydw_asmtest DATAFILE '+DATA' SIZE 5M;


oradim -NEW -ASMSID +ASM -SYSPWD change_on_install
  -PFILE c:\oracle\product\10.1.0\admin\+ASM\pfile\init+ASM.ora


INSTANCE_TYPE = ASM
DB_UNIQUE_NAME = +ASM
ASM_DISKSTRING = '\\.\*:'
COMPATIBLE = 10.1.0.2.0
ASM_POWER_LIMIT = 1
USER_DUMP_DEST = 'c:\oracle\product\10.1.0\admin\+ASM\udump'
BACKGROUND_DUMP_DEST = 'c:\oracle\product\10.1.0\admin\+ASM\bdump'
CORE_DUMP_DEST = 'c:\oracle\product\10.1.0\admin\+ASM\cdump'


-----------------------------------------------------
Section 3.5.1 Oracle Managed Files

ALTER SESSION SET db_create_file_dest
  = 'f:\oracle\product\10.1.0\oradata\easydw\test';


CREATE TABLESPACE omf_test DATAFILE SIZE 1m;

DROP TABLESPACE omf_test;


-----------------------------------------------------
Section 3.5.2 Bigfiles

CREATE BIGFILE TABLESPACE data_ts SIZE 20G;


ALTER TABLESPACE data_ts AUTOEXTEND ON;