Creating Tablespaces in ASM

 
When ASM creates a datafile for a permanent tablespace, the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size.
ASM applies attributes to the datafile, as specified in the system default template for a datafile as shown in the table in Managing disk group templates
If there is a disk group named DATA, you can create a tablespace TBSLAVORO in that disk group with the following SQL statement:
CREATE TABLESPACE TBSLAVORO DATAFILE ‘+DATA’;
The following example illustrates the usage of Oracle ASM with defaults. This example enables Oracle ASM to create and manage the tablespace data file for you, using Oracle supplied defaults that are adequate for most situations.
Assume the following initialization parameter setting:
DB_CREATE_FILE_DEST = +data
The following statement creates the tablespace and its data file:
CREATE TABLESPACE tblspace;