ORA-30088 During a Table Import with DataPump (Doc ID 785202.1)

Last updated on MARCH 19, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.5
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 9.2.0.1 to 10.1.0.5

Symptoms

A DataPump import fails with the following errors:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-30088: datetime/interval precision is out of range

The failing SQL is:

CREATE TABLE "IEF"."APL_TRACING" ("IDBRIEF" NUMBER(*,0), "IDALLOC" NUMBER(*,0), "ACTION" VARCHAR2(50), "TIME_LOCAL" TIMESTAMP (9), "TIME_EXEC" INTERVAL DAY () TO SECOND (9), "TIME_CUMUL" INTERVAL DAY () TO SECOND (9)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms