SQL> select substr(owner,1,20) owner, substr(object_name,1,20) object_name,
  2         substr(object_type,1,20) object_name
  3    from dba_objects
  4   where object_name = 'SSP_EI'
  5     and owner       = 'SSOWNER';

OWNER                OBJECT_NAME          OBJECT_NAME
-------------------- -------------------- --------------------
SSOWNER              SSP_EI               TABLE

SQL>

SQL> select privilege
  2    from dba_sys_privs where grantee = 'SSOWNER';

PRIVILEGE
----------------------------------------
CREATE MATERIALIZED VIEW

SQL> CREATE MATERIALIZED VIEW LOG ON SSOWNER.SS_INC WITH PRIMARY KEY INCLUDING NEW VALUES;

Materialized view log created.

SQL> CREATE MATERIALIZED VIEW ssowner.ssp_ei_MV
  2    NOLOGGING
  3    CACHE
  4    BUILD IMMEDIATE
  5    REFRESH FAST ON COMMIT  AS
  6              SELECT EI.*
  7                FROM ssowner.ssp_ei EI
  8               WHERE Nvl(EI.Modify_Ts, EI.Create_Ts) > '01-JAN-19';
             WHERE Nvl(EI.Modify_Ts, EI.Create_Ts) > '01-JAN-19'
                                                     *
ERROR at line 8:
ORA-01031: insufficient privileges

SQL>

SQL> grant CREATE MATERIALIZED VIEW to test identified by test;

Grant succeeded.

SQL> alter user test quota unlimited on ts_d01;

User altered.

SQL> create table test.t (col number primary key);

Table created.

SQL> CREATE MATERIALIZED VIEW LOG ON test.t WITH PRIMARY KEY INCLUDING NEW VALUES;

Materialized view log created.

SQL> alter user test quota 0 on ts_d01;

User altered.

SQL> CREATE MATERIALIZED VIEW  test.mv NOLOGGING CACHE BUILD IMMEDIATE REFRESH FAST ON COMMIT  AS
  2  select * from test.t
  3  /
select * from test.t
                   *
ERROR at line 2:
ORA-01031: insufficient privileges

SQL> select to_date('01-JAN-19') from dual;
select to_date('01-JAN-19') from dual
               *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> CREATE MATERIALIZED VIEW ssowner.ssp_ei_MV
  2    NOLOGGING
  3    CACHE
  4    BUILD IMMEDIATE
  5    REFRESH FAST ON COMMIT  AS
  6              SELECT EI.*
  7                FROM ssowner.ssp_ei EI;
              FROM sspowner.ssp_ei EI
                            *
ERROR at line 7:
ORA-01031: insufficient privileges

WHERE Nvl(EI.Modify_Ts, EI.Create_Ts) > to_timestamp('01-JAN-19','dd-MON-rr')

WHERE Nvl(EI.Modify_Ts, EI.Create_Ts) > to_timestamp('01-JAN-2019','dd-MON-yyyy')