That is a good question. I have the Oracle 10g ODAC install on my 64 bit SQL Server. I use it against an Oracle 9 database. I...

I have already tried DBCC ShrinkFile and DBCC ShrinkDatabase with no luck. It basically only shrinks to the size of the Intial Size setting.

There is no 64 bit Microsoft OLE DB Provider for Oracle. You have to use the Oracle OLE DB Provider. You can get that from installing ODAC on...

You need to install ODAC from Oracles site.

http://www.oracle.com/technology/software/tech/windows/odpnet/index.html