Re: SQL Server 6.5 to Oracle ODBC Replication

Rich Holoch wrote:
>
> I've got to replicate from SQL Server 6.5 to Oracle, and it works
> just long enough to add table entries to Oracle's data dictionary
> (the table shows up in all_tables), and it does allocate a block for
> wach table. But when I actually try to query the replicated table,
> I get the Oracle ORA-942, "table or view does not exist".
>

[snip]

I figgered it out. SQL Server 6.5 creates the Oracle objects using quoted identifiers. This means you either have to enjoy putting double quotes around table and column names when you query or manipulate your objects, OR, write stored procedures that prevent the (default) quoted identifiers from being used. The SQL Server 6.5 Secrets book (Fedorchek) unlocked this puzzle for me!

Rich Received on Fri Nov 08 1996 - 00:00:00 CET