Ok. I have seen several pieces of documentation on this. Lots of tutorials out there. However all of the sites and tutorials do not have all the steps mentioned clearly. I am trying to make this as comprehensive as possible. Try this on a Trial or test Portal Server, preferably a VM with a Snapshot …
Assuming you have exported the database from user qldsadmin, use the following command imp system/password fromuser=qldsadmin touser=qldsadmin log=d:import.log file=dump.dmp