My database drive(F:)size is full and also the tablespaces are also near to 90%. So I cann't add datafile to tablespace bcoz the drive is having only 2 gb free space .
G: Drive is having 100 gb Free Space.
Now I want to move the tablespace or datafile from F: drive to G: and add datafile to new Drive(G:).
Can anybody tell me how to move tablespace to datafile??????