|
Just as with MariaDB, Oracle table definitions have extra table_options at the end.
For example:
"CREATE TABLE db1.t1
|
(
|
...
|
)
|
SEGMENT CREATION IMMEDIATE
|
PCTFREE 20 PCTUSED 80 INITRANS 1 MAXTRANS 255
|
NOCOMPRESS LOGGING
|
STORAGE(INITIAL 16384 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645
|
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
TABLESPACE "USERS"
|
CACHE;"
|
Most of this can be ignored but we should consider honoring:
[NO]COMPRESS
TABLESPACE "x" (this just names the ibd file)
ENCRYPT
|