QUOTE (Keerti @ Apr 15 2017, 02:18 AM)
can anyone suggest script?
As per the screen shot you have given here. There seems to be with the tablespace name ('exit;'), which is non-existent in the database.
Normally you can add a datafile to any existing tablespace name in the below format:
alter tablespace '&existing_tbs_name' add datafile '+<DG_NAME>' size 100M autoxtend on 50M maxsize unlimited;
maxsize unlimited --> your datafile will grow until the file size limit based on your db_block_size --> if db_block_size is set to 8K then your datafile will grow till 32 GB.
you can provide any limit for maxsize, based on the db_block_size value.