Interesting question a customer had last week during the Upgrade Workshop in Munich. He’s getting export dump files from several customers and often not much information describing the contents. So how can ge find out what’s in there, which was the source characterset etc.
This seems to be a simple question but it did cost me a few searches and tests to come back with some (hopefully) useful information.
First attempt: $strings expdp.dmp > outexpdp.txt
I bet there are better ways to do this but in my case this will give me:
"APP"."SYS_EXPORT_SCHEMA_01"
x86_64/Linux 2.4.xx
WE8ISO8859P15
LBB EMB GHC JWD
… Continue reading...