OraFAQ Forum: Server Administration » Error while inserting into MS-SQL Server from Oracle using HS

Home » RDBMS Server » Server Administration » Error while inserting into MS-SQL Server from Oracle using HS

Sun, 23 July 2006 23:28

kmsalih
Messages: 197
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

Mon, 24 July 2006 21:59

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

Thu, 27 July 2006 04:38

kmsalih
Messages: 197
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: Fri Sep 20 10:42:24 CDT 2024