4 Replies Latest reply: Oct 18, 2013 5:41 AM by jajaja RSS

    backup/restore file size


      Good morning,


      I/m a newbie to oracle, so please be patient.


      I had a full test-database. I tested my application. Now I want to deploy an empty database on another location. So, I did a backup and a restore. (first set archivelog to true, using the sql-command line).

      To my surprise the restored datafile has the same size as the full database. I expected it to be very small. In the database I use to work with (firebird) a backup and restore is a way to clean up your data and get rid of empty space....

      Oracle seems to handle this in a different way. What am I missing?


      Thank you,