Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create View on Remote ( Linked ) Server ?

Re: Create View on Remote ( Linked ) Server ?

From: jpearson <jpearson96_at_earthlink.net>
Date: Sun, 12 Aug 2001 17:32:11 GMT
Message-ID: <v4zd7.4721$ZM2.457822@newsread2.prod.itd.earthlink.net>

hi,

    when you create your view, you might want to include the hint /*+ RULE */ if you do not have up to date statistics or if you use tables from both instances....... if you do not, execution time might be poor in nature.

    just a bit of my brain....

j

"Frank" <franjoe_at_frisurf.no> wrote in message news:nHrb7.270$ep5.5346_at_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 Sun Aug 12 2001 - 12:32:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US