Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

How to solve invalid objects when i "transporte a Database Using an Export Dump File"?

Hello everyone, I have a problem to be solved, please help。

i transporte a Database Using an Export Dump File,the impdp command is:

expdp system/oracle1234 full=y transportable=always version=12.0 directory=expdp_dir dumpfile=full.dmp logfile=full.log

(source db version:11.2.0.4 dest db version:19.13)

I find there are some invliad obejcts in the dest database:

select owner, count(*) from dba_objects where status = 'INVALID' group by owner;

How to fixup these invalid objects?


Thanks very much。

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