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:
Maxsize: upto 32G for 8k blocksize and 64G for 16K block size.