This content has been marked as final. Show 2 replies
you can folllow below steps to complete your activity
shut down database. copy datafiles from c dirve to required drive.
then start the database in mount stage. then use alter database rename datafile <old_location> to <new_location>
then open the database.
cross verifies with following query
select file_name from dba_data_files;
if this is locating your files to new location.
then remove the c: datafiles anc clear the space