{toc}
h2. 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.
{gliffy:name=create table syntax in oracle\|align=left\|size=L\|version=6}Oracle relational table is mainly composed of 3 parts.
* relational properties
* physical properties
* table properties
{note}
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.
{note}
h2. Relational properties
ALTIBASE HDB does not support functions listed below in relational properties.
* cluster
* column encryption
* virtual column
* Object Type
* XML Type
* supplemental logging
ALTIBASE HDB column definition is similar to Oracle's one.
The part of constraints is described in Constraint of Data conversion.
h2. Comparison of Functionality
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 \\ |
h2. Table properties
ALTIBASE HDB does not support as shown below in table properties.
* object type column properties
* nested table column properties
* varray column properties
* XML type column properties
* cache / nocache
* parallel clause (This feature is different with ALTIBASE HDB)
* global partitioned index
* row movement clause
* flash back clause
* SECUREFILE is not supported in LOB storage. |