The procedure is same as setting up mysql metastore. You need to use the jdbc driver/jar corresponding to the oracle version/release you are intending to use.
Sent from remote device, Please excuse typos
From: Raj Hadoop <[EMAIL PROTECTED]>
Date: Fri, 17 May 2013 17:10:07
To: Hive<[EMAIL PROTECTED]>; User<[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Hive on Oracle
I am planning to install Hive and want to set up Meta store on Oracle. What is the procedure? Which driver (JDBC) do I need to use it?