This discussion is archived
4 Replies Latest reply: Oct 18, 2013 3:41 AM by jajaja RSS

backup/restore file size

jajaja Newbie
Currently Being Moderated

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,



  • Correct Answers - 10 points
  • Helpful Answers - 5 points