Can I set a default table space for Index and Tables?

indexing, oracle

Solution

Sorry, there is no way to do that.

A default tablespace may be set per user, but it applies to all segment creation: tables, indexes, materialized views, etc.

Hope that helps.

Problem

Currently by default create table and index DDLs will place tables in `MYDB_DATA_TABLE_SPACE`, I would like to specify a different default table space for indexes from table data so that I do not have to always explicitly mention that in my create index DDL. Is this possible? Current: ``` Table -> MYDB_DATA_TABLE_SPACE ``` Required: ``` Table -> MYDB_DATA_TABLE_SPACE Index -> MYDB_INDX_TABLE_SPACE ```

Original source