Originally posted by a128
I need to upgrade existing DBs from 8.1.7.3 to 9.2.0.1. For those who have experiences with this upgrade path, are there any gotchas?
No.

Originally posted by a128

Also, can I upgrade 8.1.7.3 Standard edition to 9.2.0.1 Enterprise edition in one shot?

Appreciated.
Depends. If you are a good dba then yes. If not then no.