Table

Overview

"CREATE TABLE" statement is made up of main 3 parts in Oracle. Relational table, Object table, XML type table.

ALTIBASE HDB does not support Object type and XML type.

So we can't describe object table, XML type table.

We only explain relational table.

Full Size

Oracle relational table is mainly composed of 3 parts.

Icon

ALTIBASE HDB does not support global temporary table.

ALTIBASE HDB Volatile tablespace is no-logging tablespace.

You can create table in using a Volatile tablespace, and it is used like temporary table.

But this table is same with normal table except for volatility.

That is, data remain until DB shut down.

ALTIBASE HDB does not support functions listed below in relational properties.

ALTIBASE HDB column definition is similar to Oracle's one.

The part of constraints is described in Constraint of Data conversion.

Comparison of Oracle with ALTIBASE HDB about Storage clause is described as below.

Oracle	ALTIBASE HDB	Comments
SEGMENT CREATION [ IMMEDIATE \| DEFERRED ]		not supported
INITIAL	INITEXTENTS
NEXT	NEXTEXTENTS
MINEXTENTS	MINEXTENTS
PCTINCREASE	MAXEXTENTS
FREELISTS		not supported
FREELIST		not supported
BUFFER_POOL		not supported
FLASH_CACHE		not supported
COMPRESS \| NOCOMPRESS		not supported

ALTIBASE HDB does not support as shown below in table properties.