I am going to use RMAN to duplicate a database. When RMAN duplicates the database, does it restore the datafile sizes exactly the same (i.e. datafile size is 500MB but using only 200MB) in this case 500 MB , or restore the datafile what is actually being used i.e. 200MB?
My guess is 500MB because a duplicate is an exact copy of an existing database. Am I right?