Re: Create View on Remote ( Linked ) Server ?
Date: Mon, 6 Aug 2001 09:28:22 +0200
Message-ID: <nHrb7.270$ep5.5346_at_news1.oke.nextra.no>
Hi!
[Quoted] 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 - 09:28:22 CEST