Creating Tablespaces in ASM
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”. You can also create and specify your own template.
Files in a tablespace might be in both ASM files and non-ASM files as a result of the tablespace history. RMAN commands enable non-ASM files to be relocated to an ASM disk group and enable ASM files to be relocated as non-ASM files.
For example, if there is a disk group named dgroup3, you can create a tablespace tblspace3 in that disk group with the following SQL statement:
CREATE TABLESPACE tblspace3 DATAFILE ‘+DGROUP3’;