Issue after datapump import with grants
After importing a dump into a database 11.2.0.4.0 - 64bit linux from export created on 11.2.0.3.0 on os solaris etlb view is created and valid.
Export was done as one user and import as another.
Export was done using
dumpfile=INTSTGP_full_norows_1202091344.dpdmp full=Y content=metadata_only logfile=INTSTGP_full_norow
s_1202091344.log directory=PROD_EXP
Parfile used to import an was:
EXCLUDE=SCHEMA:"IN ('SYS','SYSTEM','PATROL','OUTLN','APPQOSSYS')"
remap_tablespace=tools:tools_auto_01
remap_tablespace=users:users_auto_01
remap_tablespace=SYSAUX_DATA_AUTO_01:sysaux
table_exists_action=replace
View is define as :
"CREATE OR REPLACE VIEW INTETL.ETL_VERSION AS