Hi
System details:
Windows server 2008
Oracle 11.2.0.3.0
My data file in test database grown too huge(13G) so I am trying to get some space
SQL> alter database datafile 'path\data file.DBF' resize 12G;
alter database datafile 'path\data file.DBF' resize 12G
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
Before this step, I had checked which tables belonging to that tablespace and some of them belonged to test schemas which i didnt want so i dropped those schemas
(All the tables in that schema were big and belonged to the tablespace which contain the above data file)
Does dropping user would not free space on the data file?
Please let me know what other way I can shrink space on the above data file?
I have even dropped a few big tables on that tablespace but the data file still not shrinking.
thanks