I am having a senario that i have to create a tablespace that has two datafiles. One datafile is used for storing usres data and other is for index storage.
How can i specify this while creating table spaces.
I have searched for this but i am not able to find a suitable purpose. I found that create two tablespaces and store the data and indexes seperately.
Can any one suggest that how can i achieve this? Is this possible or not.