866995 wrote:As noted in the documentation, you should not use sysdba for export/imports. Oracle has a very good reason for making that statement.
Thanks for your suggestion. Actually we always use sysdba and not system, I dont think there will be any problem but still as you suggested I will try with system as well.
I have couple of question for you:Yes - pl see this link - http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#BABFHFIJ
1) Currently there is more Fragmentation in our database. Is going with datapump export/import upgrade method the correct way to deal with it in Production server?
2) What is the Oracle recommended best practice for database Upgrade. As per my knowledge and docs it is DBUA?Yes - this is the recommended method - http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#i694345
3) What about DBMS scheduler jobs. Do we need to re-create them after the Upgrade?Scheduler jobs will be exported/imported - http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedadmin003.htm#i1007297