Skip to end of metadata
Go to start of metadata

Phenomenon

Since indexes are basically created in the same type as the table, indexes of disk tables cannot be created in the memory tablespace, and an ERR-311EC error is displayed.

  • Create test table T1 in disk tablespace

iSQL> create table t1 (c1 char(10), c2 char(5)) tablespace SYS_TBS_DISK_DATA;
Create success.

  • Create an index for the test table in the memory tablespace

If the user tries to create a disk table index in the memory tablespace (SYS_TBS_MEM_DATA) as shown below, an ERR-311EC error occurs.

iSQL> create index idx_t1 on t1(c1 desc) tablespace SYS_TBS_MEM_DATA;
[ERR-311EC : The type (memory/disk/volatile) of the tablespace in which to create the index is not the same as the type of the table.]

 

Solution

If the index of the disk table is created in the disk tablespace, it is created normally without causing an error.

  • Create disk table index in disk tablespace

    iSQL> create index idx_t1 on t1(c1 desc) tablespace SYS_TBS_DISK_DATA;
    Create success.

 

 

 

  • No labels