--
-- RMAN UNUSED BLOCK COMPRESSION DEMO on Windows XE 10.2.0.1
--
CREATE TABLESPACE tong_test DATAFILE 'D:\oraclexee\oradata\XE\tong_test_01.dbf' SIZE 10m ;

SELECT file# FROM v$datafile WHERE name = upper('D:\oraclexee\oradata\XE\tong_test_01.dbf') ;

5

rman target /

BACKUP DATAFILE 5 ;

dir D:\ORACLEXEE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2008_03_08\O1_MF_NNNDF_TAG20080308T115927_3X4RVZH4_.BKP 

08.03.2008  11:59            98.304 O1_MF_NNNDF_TAG20080308T115927_3X4RVZH4_.BKP

SELECT 98304/1024 KB FROM dual;

96

dir D:\oraclexee\oradata\XE\tong_test_01.dbf

08.03.2008  11:56        10.493.952 TONG_TEST_01.DBF

SELECT 10493952/1024 KB FROM dual;

10248

CREATE TABLE tong_tab ( sp1 NUMBER) TABLESPACE tong_test;

BEGIN
 FOR i IN 1..100000 LOOP
  INSERT INTO tong_tab values(i);
 END LOOP;
END;
/
COMMIT;

BACKUP DATAFILE 5 ;

dir D:\ORACLEXEE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2008_03_08\O1_MF_NNNDF_TAG20080308T120741_3X4SCSKL_.BKP 

08.03.2008  12:07         9.535.488 O1_MF_NNNDF_TAG20080308T120741_3X4SCSKL_.BKP

SELECT 9535488/1024 FROM dual;

9312

DELETE FROM tong_tab;
COMMIT;

BACKUP DATAFILE 5 ;

dir D:\ORACLEXEE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2008_03_08\O1_MF_NNNDF_TAG20080308T121025_3X4SJLB8_.BKP 

08.03.2008  12:10         9.535.488 O1_MF_NNNDF_TAG20080308T121025_3X4SJLB8_.BKP

TRUNCATE TABLE tong_tab;

BACKUP DATAFILE 5 ;

dir D:\ORACLEXEE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2008_03_08\O1_MF_NNNDF_TAG20080308T121307_3X4SOML2_.BKP 

08.03.2008  12:13         9.535.488 O1_MF_NNNDF_TAG20080308T121307_3X4SOML2_.BKP