DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Compilation Error

Threaded View

  1. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    But the table is on a remote machine. There is a private synonym that uses a db_link connecting as the table owner of the remote table, so privs arent an issue:

    Code:
    SQL> create user blah identified by blah;
    
    User created.
    
    SQL> grant CREATE SESSION, create synonym, create database link to blah;
    
    Grant succeeded.
    
    SQL> conn blah/blah
    Connected.
    
    SQL> create database link fc.world connect to ice identified by **** using 'icepw01.world';
    
    Database link created.
    
    
    SQL> create synonym blah for [email protected]d;
    
    Synonym created.
    
    SQL> select count(*) from blah;
    
      COUNT(*)
    ----------
            76
    Last edited by JPnyc; 06-03-2009 at 08:29 AM.

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