Sybase ASE – Read a dumpfile with headeronly

We can use the “headeronly” qualifier when reading a dumpfile to extract useful information which we can use to work out what is needed to setup a new database to load the given dump file. Using following command to read the dumpfile:- load database headerfrom “compress::<dumpfile_path_and_name>”with headeronlygo This would generate a output something like:- Backup…

How to read Datapump Dumpfile Headers

Ever got into a scenario where you have a dump file without the logfile and not even sure what was the Oracle database version from where this was exported, the characterset, Operating system and other details of the Source Database ? Or even when you are not aware of which utility was used to export…