Database DataWarehousing (MOSC)

MOSC Banner

Missing grants in import

edited May 26, 2017 12:10PM in Database DataWarehousing (MOSC) 3 commentsAnswered

Source : 11.2.0.4

Target : 12.1.0.2

Source export command

Starting "XBORAORA"."SYS_EXPORT_FULL_01":  xboraora/********@DVNFAC01 parfile=/xboraora/control/DVNFAC01_DVNFAC01_exp.par FULL=Y CONTENT=METADATA_ONLY VERSION=11.2.0.4.0 REUSE_DUMPFILES=Y NETWORK_LINK=xb_DVNFAC01 DIRECTORY=xboraora_dir DUMPFILE=expfull.dmp LOGFILE=expfull.log

Estimate in progress using BLOCKS method...

Import sql file to check the metadata before actual import

Starting "XBORAORA"."SYS_SQL_FILE_FULL_01":  xboraora/********@DVNFAC01 parfile=/xboraora/control/DVNFAC01_DVNFAC01_ddl.par FULL=Y CONTENT=METADATA_ONLY DIRECTORY=xboraora_dir DUMPFILE=expfull.dmp LOGFILE=struexp.log SQLFILE=struexp.dmp

this is executed on a dev environment

Observed lot of objects are invalid. after import

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