Cross database query

[citychap26]

Hi All,

Just to put you in the picture, I am a Sybase developer (No jokes please) but need to get data out of Oracle. I am not allowed to use TOAD to get my data (which is a pain in the arse). However I have been told that I can create a cross database query that can do a "insert into table_x select from table_y. How would I do this in Oracle. Note that the new table will be in another Oracle database.

Cheers

SK

 

[HimanB]

Hi,
You would require a Database link between the two databases.

and then issue the query from target db to source db(e.g. dbn200):

create table a as select * from from schemaname.tablename@datbaselinkname;

HTH
Regards
Himanshu