I have a database running on an 11g database. I need to move it to a new system running an new installation of 19c. Since I really have no idea what I am doing, I have taken my best guess and tried doing this by exporting (expdp) the full database from the old and them importing (impdp) the data file to the new database. I get lots of errors, and anyway, I am sure this is not a good way to do this.
I have also tried just exporting and importing only the schema. One porblem I get doing this is that the account does not exist -- I suppose all I may have to do in this case is just create an account? The other issue I have with this is that the database has several users with permissions on the schema in question and transferring just the schema does not transfer the other users and their privileges.
What is the prescribed way to make this migration?