ORA-39083 & ORA-14308 during export/import on partition table (Doc ID 2689483.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ORA-39083: Object type TABLE:"<SCHEMA NAME>"."<TABLE NAME>" failed to create with error:
ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

while debugging we found in ddl of the table-partition Null is passed in values

 PARTITION "SYS_P47711" VALUES ('') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.