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 .
You can create two tablespaces, put all the data files for one tablespace on one drive and all the data files for the other tablespace on the other side, and then create the tables in whichever tablespace you would like. It seems unlikely, however, that you would really want to do this. It is very unusual to run a database on a server without any sort of RAID configuration. And it is generally the case that any automatic I/O load balancing that you would implement would outperform your manual load balancing.