Re: Help migrating from 8.1.7 to (yes) 8.1.5

In article <185bc2bb.0206071222.199acbd0_at_posting.google.com>,  zaq42_at_yahoo.com (zaq) wrote:

> Our client is running Oracle 8.1.5. Even though we are a rather large
> consulting firm, we're an SQL Server shop. Our 8.1.7 instance is what
> we got. I've been working on exporting 8.1.7 data to 8.1.5. I had to
> request client tools from our client (embarassing). But it still did
> not work, because of a known bug with 8.1.5 client tools (oravsn.dll
> is missing from CD). The 8.1.5 server is Unix, so that is no help.

This isn't a serious post, is it? Really?

Nonetheless, I will attempt to answer it seriously.

First, there are some SERIOUS and potentially FATAL bugs in Oracle 8.1.5. If you have any sway with your client, advise them... no, INSIST that they upgrade. Given that Oracle isn't providing support for 8.1.5, you put both you and your client in grave danger by continuing down this path.

However...

It's been a while, but I think if you set the COMPATIBLE parameter equal to 8.1.5 on your 8.1.7 instance and then use the EXPort utility to dump the schema, then use the IMPort utility on the server side to bring the data in. You shouldn't need any other tools.

> I need some innovative ideas on how to transfer all 48 tables in a
> tablespace to our client. Should I write create scripts and export it
> all to CSV? Should I pull it into Access and use Oracle's Migration
> Workbench?

Whew. When all you've got is a hammer, every problem begins to look like a nail, doesn't it?

-- 
The underscore character does not belong in my address. You know the drill...