1 Reply Latest reply: Jan 7, 2014 2:44 PM by RickG RSS

where are the indexes stored ?

vinay raj Newbie
Currently Being Moderated

Hi all..

I hav a small doubt..

I have created a user and specified its default tablespace as a user defined tablespace namely sample .

If i have created a table where does the table get stored and if i have created an index on one of its column of that table where does the index get stored ..

Now my doubt is whether the index gets stored in the sample tablespace datafile or system tablesapce data file ??


Thanks in advance..


  • Correct Answers - 10 points
  • Helpful Answers - 5 points