Re: Create View on Remote ( Linked ) Server ?

From: Frank <franjoe_at_frisurf.no>
Date: Mon, 6 Aug 2001 09:28:22 +0200
Message-ID: <nHrb7.270$ep5.5346@news1.oke.nextra.no>

Hi!

Look up Database link in manual, it is something like:

CREATE PUBLIC(?) DATABASE LINK a_database_link_name CONNECT TO the_user_in_remote_database
IDENTIFIED BY his_password USING 'connect string';

'connect string' is the same string as you would use when logging in from the command prompt something like: sqlplus scott/tiger_at_ASID.city.company.nation

CREATE OR REPLACE VIEW v_my_views AS
SELECT *
FROM table_at_a_database_link_name
/

Frank

Guido Schmitz <gschmit6_at_ford.com> wrote in message news:9klc3b$pcp17_at_eccws12.dearborn.ford.com...
> I have a local Server ( Oracle 8 ) and i want to create a view to a table
on
> an other Server ( oracle 7) how can i do this ?
>
> regards Guido
>
>
Received on Mon Aug 06 2001 - 02:28:22 CDT