SQL>select count(*) cnt from test
3000000
SQL> select tablespace_name,file_name,file_id,bytes/1024/1024 as "size(M)"
2 from dba_data_files;
TABLESPACE FILE_NAME FILE_ID size(M)
---------- ---------------------------------------- ---------- ----------
USERS F:\ORACLE\PRODUCT\10.1.0\ORADATA\ZHONGXIN\USERS01.DBF 4 2790
SQL> DROP TABLE test
SQL> select tablespace_name,file_name,file_id,bytes/1024/1024 as "size(M)"
2 from dba_data_files;
TABLESPACE FILE_NAME FILE_ID size(M)
---------- ---------------------------------------- ---------- ----------
USERS F:\ORACLE\PRODUCT\10.1.0\ORADATA\ZHONGXIN\USERS01.DBF 4 2790
drop 前后大小没变!
SQL>pruge recyclebin
SQL> select tablespace_name,file_name,file_id,bytes/1024/1024 as "size(M)"
2 from dba_data_files;
TABLESPACE FILE_NAME FILE_ID size(M)
---------- ---------------------------------------- ---------- ----------
USERS F:\ORACLE\PRODUCT\10.1.0\ORADATA\ZHONGXIN\USERS01.DBF 4 2790
大小还是没变!
而我从oracle 9i 的oem中看到的只使用了14.5M
所以:
SQL> alter database datafile 4 resize 1024M;
alter database datafile 4 resize 1024M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
为什么不给我resize ,我如何做才能resize 到1024M以下??