December 11, 2005 at 11:23 pm
Hi All,
I am migrating data from SQL Server to ORACLE through TG4MSSQL utility. When i am copying data from the table i dont have any problems but when i am copying data from sql server's view.. i get the following error:
ERROR at line 48:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from DBL_GETGC1
In oracle when i switch trace on i get the following message :
HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: Read error.
HS Agent received unexpected RPC disconnect
Network error 1004: NCR-01004: NCRS: Write error.
Anyone who has faced similar problem while migrating data from sql server to oracle pls help me out.
Regards,
Rajesh
December 13, 2005 at 7:35 am
Why not turn the view into a table sql 2000
select *
into tabletocopy
from viewwithdata
Ralph
December 13, 2005 at 7:39 am
Is it a permission issue? Does the login used by the Oracle connection have select permissions on the view?
Are the tables and views owned by the same user?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply