ORA-00998 at imp or impdp for CREATE VIEW Using CURRENT_TIME Column
(Doc ID 2232974.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!