Home » RDBMS Server » Server Administration » Error while inserting into MS-SQL Server from Oracle using HS
Error while inserting into MS-SQL Server from Oracle using HS [message #183803] Sun, 23 July 2006 23:28 Go to next message
kmsalih
Messages: 198
Registered: March 2006
Senior Member
Hi,

I am using hetrogeneous connection.

I want to insert into MS-SQL Server Table by selecting from Oracle Tables.

insert into tableone@mssql  select * from table2;

Table2 is in oracle database.

while executing i'm getting

ORA-02025: all tables in the SQL statement must be at the remote database


Please help me in this issue

Regards
Salih KM
icon13.gif  Re: Error while inserting into MS-SQL Server from Oracle using HS [message #184014 is a reply to message #183803] Mon, 24 July 2006 21:59 Go to previous messageGo to next message
bravobritto
Messages: 6
Registered: July 2006
Location: Somewhere in India
Junior Member

Check whether you set the right permission on the user for the table.

Regards
Britto Razz
Re: Error while inserting into MS-SQL Server from Oracle using HS [message #184625 is a reply to message #184014] Thu, 27 July 2006 04:38 Go to previous message
kmsalih
Messages: 198
Registered: March 2006
Senior Member
i am able to select from remote table using database link

also using the database link i am connecting as sa user in MS-SQL Server Database.

Previous Topic: national characters
Next Topic: Regardind the Patches applied
Goto Forum:
  


Current Time: Tue Dec 06 00:10:12 CST 2016

Total time taken to generate the page: 0.09567 seconds