I am buying a new server than has two HDs: 300 GB with 15000 rpm. 600 GB with 10000 rpm.
I am thinking to allocate the datafiles in both hard disks. and put the less used tables in the data files that reside in the slower HD that is 600 GB with 10000 rpm.
So, Can we create a table in specific data file - ?
I am using Oracle 11g R2 SOE .