ORA-00998 or ORA-932 at imp or impdp for CREATE VIEW Using CURRENT_TIME Column (Doc ID 2232974.1)

Last updated on APRIL 14, 2023

Applies to:

Symptoms

Getting ORA-998 at either DataPump import (impdp) or traditional import (imp) when it creates an editionable view which contains current_time in the syntax:

CREATE OR REPLACE EDITIONABLE VIEW test_view as
select comp_ci_obj_nr, current_time,down_days from
(
select
1 comp_ci_obj_nr,
sysdate current_time,
0 down_days
from dual
) incidents
model
dimension by (current_time)
measures(down_days)
rules update (down_days[any]=0)
WITH READ ONLY;

The same syntax is successful in SQL*Plus.

Another possible error is:

ORA-00932: inconsistent datatypes: expected TIME WITH TIME ZONE got NUMBER as explained in Internal bug 30985910

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00932: inconsistent datatypes: expected TIME WITH TIME ZONE got NUMBER

Changes

 NONE

Cause

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