Hello community,
I am facing a bit of a problem here. I have to upgrade my Database from 10.2.0.4 on Windows Server 2003 to 12.1 on Red Hat 5 RAC. All Enterprise Edition.
I am fully aware that a direct upgrade from 10.2.0.4 is not possible, and I found out that the Full Transportable Import is only available if the source DB is at least 11.2.0.3.
Since my DB is about 5TB large and full of BLOB fields, and doing an DP export/import would take a HUGE amount of time (it is a production DB and I can't block all the activity for too long) I was wondering if there are other methods to get my data form A to B. Is a full network EXP/IMP possible without having to use up another 5TB of disk space just for the dump? Would it be faster or slower? Are there any alternatives? Can I just copy the datafiles and get the new DB to read them?
Thanks for the attention!