Login  Register

invalid objects in sys user

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

invalid objects in sys user

Arsalan
184 posts


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
| More
Print post
Permalink

Re: invalid objects in sys user

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