ORA-00998 at imp or impdp for CREATE VIEW Using CURRENT_TIME Column

Last updated on FEBRUARY 13, 2017

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.

Cause