Database Utilities (MOSC)

MOSC Banner

Issue after datapump import with grants

edited Dec 26, 2013 9:40PM in Database Utilities (MOSC) 9 commentsAnswered
Hi

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

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