Hi this is production server. Due recent increase of space usage, A new mount point /oracle/oradata2 have been created with 600GB on server ***dbprod.
"If Addtional space is required, please use the new mount point, the data files should be under /oracle/oradata2/prod. Please make sure the filenames are unique within the tablespaces. The original mount point /oracle is at 97%, we should not adding or expending any datafile there whenever possible. "
Please give me steps in brief to do this activity.