You posted in BT2004 forum. BT2004 does not have a built-in Oracle adapter but 2006 does. If you need an Oracle adapter for BT2004, check http://TopXml.com or other vendors.
If you are asking aobut the Oracle Adatper in BT2006 – please specify, but I don’t know anything about it. Hopefully someone else can answer.