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..
Since you cannot create database users with the Database Cloud Service, I suspect you are asking this question in the incorrect forum. With the Database Cloud Service, you are limited to a single tablespace.
Hope this helps.
- Rick Greenwald