Our Oracle Database tablespace is full and our database is using ASM. How to add datafiles in ASM Storage?
Datafiles can be a part of file system or ASM Storage. If database is using ASM storage then you need to check the diskgroup name to add the datafiles.
Steps to add datafile in ASM:
Check diskgroup location to add datafiles:
show parameter db_create_filedest;
ALTER TABLESPACE tablespace_name ADD DATAFILE 'LOCATION' SIZE 10M AUTOEXTEND ON MAXSIZE 10G;
Maxsize: upto 32G for 8k blocksize and 64G for 16K block size.