or with a case statement

select

CASE

WHEN DESCRIPTION= 'Stop save' then 'gddo'

ELSE 'turr'

END DEP

from CIRC.TAG

a small recap (and in what order?)

you have installed the 32-bit database (was this software only?) at oraclehome1 (not necessary), oracleinstaller not found?

you have installed the 64-bit client at oraclehome2,...

Hello,

*try at dev-environment first*

You have downloaded the full database versions instead of the clients.

You can download the 32-bit client (win32_11gR2_client.zip)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

You can download the 64-bit client (win64_11gR2_client.zip)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Usually install the 64-bit client...

At the server running the SSIS package you already have an Oracle-client installed (otherwise you couldn't make a connection).

The location of the different oracle clients should show up uner "All...

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/