Create a view using tables from other instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Create a view using tables from other instance

  1. #1
    Join Date
    Jul 2000
    Posts
    10
    HI all,

    Is there any method to create a view that use the table structure in other instance !?

    Thanks in advanced.

    Dennis

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    CREATE OR REPLACE VIEW remote_emp AS
    SELECT * FROM scott.emp@link_to_remote_db;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jul 2000
    Posts
    10
    Hi Jmodic,

    How to define the link_to_remote_db ?
    thanks your help !

    Dennis

  4. #4
    Join Date
    Jul 2000
    Posts
    10
    HI Jmodic

    I just found the database link in Oracle schema manager.
    Anyway, thx for your kindly help.

    Dennis

  5. #5
    Join Date
    Mar 2001
    Posts
    3

    Using data from other oracle instance

    Originally posted by scansir
    HI Jmodic

    I just found the database link in Oracle schema manager.
    Anyway, thx for your kindly help.

    Dennis
    Hi,

    I have created a link thru scheme manager using system/manager as public. after this i am loggin into that user where i want to use this link. after giving command like

    select * from mgisys2001.fnadvmem@MGIDATA2001;

    in sqlplus it says TNS could not resolve service name & puts a * below MGIDATA2001. this is the link name.

    do i need to give any rights to that user who wants to use this link. i have already made a public link.

    km
    km

  6. #6
    Join Date
    Sep 2000
    Posts
    4
    Hi
    Define remote Server Alias in TNSNAMES.ORA in your DB Server (not in Client Side)

    shahab

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width