all groups > sql server replication > july 2004 >
You're in the

sql server replication

group:

Snapshot replication error


Snapshot replication error Urko
7/14/2004 3:03:02 AM
sql server replication:
Hello,
During the process of replication from SQL Server to Oracle i
get the error "The process could not allocate memory" and the
last command executed is SELECT * FROM Table WHERE 0 = 1.

Thank's in advance.

Re: Snapshot replication error Hilary Cotter
7/15/2004 7:37:56 AM
can you open up your linked server to oracle and issue the same query and
see what you get?

It will look like this

select * from openquery('OracleLinkedServerName','select * from table where
0=1')

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Re: Snapshot replication error Urko
7/15/2004 10:52:01 PM
Thank's Hillary a already fixed the problem.

The angent that is doing the replication obvioslly didn't had enough memory
to copy the data.

[quoted text, click to view]
AddThis Social Bookmark Button