ORA-00998 at imp or impdp for CREATE VIEW Using CURRENT_TIME Column
Last updated on FEBRUARY 13, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
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
dimension by (current_time)
rules update (down_days[any]=0)
WITH READ ONLY;
The same syntax is successful in SQL*Plus.
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