Hello All,
I am migrating my schema which sits on 11G to 19c pluggable database. here , the problem is that when I try to check schema size it says , it's around more then 200 GB , but once I take a export for that schema , it completes without any error and size is fairly small say only 200 Mb. Here ,my schema has LOB objects and when I checked , it was giving me correct size and I am wondering how come there can be huge difference ? Do I separately need to take export of LOB segments and I really doubt , if EXPDP offers any option. to achieve this. I also checked out for fragmentation , but did not see any major chunk which lying as fragmented.
Any inputs is highly appreciated here.
Regards
Alok Kumar