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.
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.