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

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

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.

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