invalid objects in sys user

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

invalid objects in sys user

Arsalan


Hello Arslan,

I hope you fine and happy,

after impdp i have invalide objects in sys schema

sys/******** AS SYSDBA schemas=sigtasad directory=export dumpfile=AFGPROD_20180829-DUMP.DMP logfile=IMP.log



i run the below procedure but i have still invalid objects sys schema



EXEC UTL_RECOMP.recomp_serial('SIGTASAD');

EXEC UTL_RECOMP.recomp_parallel(4, 'SIGTASAD');

-- Database level.

EXEC UTL_RECOMP.recomp_serial();

EXEC UTL_RECOMP.recomp_parallel(4);



Kindly guide me



Reply | Threaded
Open this post in threaded view
|

Re: invalid objects in sys user

ErmanArslansOracleBlog
Administrator
What are those objects? Send me a list of it, so I can tell you something.