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
Karma: 0
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
Karma: 0
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
Karma: 0
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: How to create second listener.
Next Topic: script creation
Goto Forum:
  


Current Time: Tue Aug 22 12:02:53 CDT 2017

Total time taken to generate the page: 0.13192 seconds