CODEWITHSUNDEEP
databaseoracle-databasedatabase-administrationoracle12c
tharindus609
tharindus609

Reputation: 59

Specify the datafile to create a table partition In a tablespace spanning multiple datafiles

Say that I have two datafiles created on two separate drives (a SSD and a Nomal HDD). I can create a tablespace which will include both the datafiles. In a typical scenario oracle will handle where each schema object for the tablespace will go and manage the storage accordingly.

But i want to take advantage of the the two datafiles in different drives and use the datafile in the SSD for a table partition which contains data i use more frequently and use the datafile in the normal HDD to create the second partition of the same table which will hold data which are not frequently used.

Can this be achieved?

On a side note: Is there any other way to do this other than partitioning?

Upvotes: 0

Views: 597

Answers (1)

atokpas
atokpas

Reputation: 3351

There is no option to specify datafiles for a partition of a table. Instead we can specify tablespace for a partition. So you can create two different tablespaces, one's datafiles resides in SSD and another's in normal HDD. And you can use these tablespaces as your IO requirements.

Reference

Upvotes: 1

Related Questions