For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I have an oracle 12c database with the following tablespace and its corresponding datafiles: I need to release the free space of datafile user_1 from the users tablespace, since at the operating system level it weighs approximately 30GB try to perform the resize statement for the indicated datafile (alter database datafile '...\DATAFILES\USER_1' resize 25000m; ) but it returns the following error: ¿ Is it necessary to run another process to be able to do what I need and allow me to resize the datafile ?