October 8, 2012

Extract list of Oracle schema names from dump file

Filed under: Oracle — Tags: , , , — Darrin Maidlow @ 8:00 am

Recently I was tasked with extracting some data from an server and converting it to 2008.   I could not get very much information about the Oracle server other than a sys password and the location of the nightly backup dump files.  The server was serving two applications with very little vendor support – but they were working.   The icing on the cake was that the the Oracle EM web app was not working – so I was also running a little blind.  I didn’t want to break anything so I opted to leave the EM non-functional and I decided to import a recent dump into a fresh scratch Oracle instance.  I would do my export to SQL server from there – zero risk of an oops.

The dumps were full system dumps and were tens of GB in size.  I needed to know the names of the schemas being backed up so I could selectively restore the schemas to my new Oracle instance.   In my messing around I accidentally loaded one of the dumps into a text editor (that was smart enough to deal with large files) and noticed it was mostly text. Keep Reading

Powered by WordPress

Switch to our mobile site