As gathered from the forums SSIS-designer uses the 32-bit driver, when SQL Server actually executes it it uses the 64-bit driver.

Do you have both oracleclient versions installed?

Shrinking should stay. Had an archival run on Oracle leaving 50% free. To shrink it I had to move all the objects to a new tablespace, "shrink" the original and...

Thanks for the input. I'll start with the books online

Turning off & on logshipping will require reinitialization. (full backup + new logfiles).

Mayhaps is it possible to delete the old data in sustainable batches for logshipping?

be sure that the correct datatypes are used , not relying on implicit conversions

I would choose 64-bit to minimize 64-to-32 bit conversions

What do folks normally use to view the data from a database if Access forms are not use? If this is more of a design question I can ask it...

Enterprise Architect can do ERD but I haven't used it much yet.

http://www.sparxsystems.com.au/

Have a look at

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/sql-server-linked-server-between-2005-64

For cannot obtain rowset you'll have to create sp_tables_info_rowset_64

I can't find the original MS KB for it at the moment

Found it:

http://support.microsoft.com/kb/906954

Raw Materials & Dilbert are of great humor to break the day.

Even ctrl+al+del is available in book/paperback.

There wouldn't be a 64-bit Jet Driver. Perhaps with the latest Office2010-64bit edition

With SSIS

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/70636/

I prefer to store the current in a live table and the history table. This way you don't have to join the live table for just 1 entry, which can...

Sometimes a reboot is required in order to fully install the oracle client

Have a look at the performance counters (windows)

SQLServer:Memory Manager: Total Server Memory (KB) : total memory for instance

SQLServer:Memory Manager: Target Server Memory (KB) : wanted memory for instance

they give an...

Consider setting max memory values for the instances. Leave some memory for the operating system (+- 2 GB)