Database Administration (MOSC)

MOSC Banner

ORA-12018,ORA-00904: : invalid identifier During MV creation -11203 AIX 6.1

edited Sep 2, 2012 8:20PM in Database Administration (MOSC) 3 commentsAnswered ✓
I'm not able to create the Materialized View with fast refresh on commit ,database  version is 11.2.0.3(AIX 6.1) .The same MV got created in 11.2.0.1.

Created the MV logs on the base tables .The MV and MV logs are in same schema ,nothing is being referenced outside the schema.

During MV creation throwing error ORA-12018

ORA-12018: following error encountered during code generation for "XMATSBX"."MV_CUST_SEARCH"
ORA-00904: : invalid identifier

CREATE MATERIALIZED VIEW XMATSBX.MV_CUST_SEARCH NOLOGGING PARALLEL 8 BUILD IMMEDIATE
REFRESH FAST ON COMMIT AS
( SELECT personprofilenames.pp_legalentity_number legal_entity_number,
personprofilenames.first_name,
personprofilenames.last_name,
personprofilenames.middle_name,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center