Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    34

    Unanswered: synonym for database link

    Hi All

    I am trying to create a synonym for database link

    using

    create synonym test for testdb.us.oracle.com;
    *

    ERROR at line 1:
    ORA-00933: SQL command not properly ended



    Is it that we cannot create a synonym for a database link
    or is there something misssing in the above SQL


    Rgrds

  2. #2
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171

    Re: synonym for database link

    As per Oracle 9i Database concepts:
    ---------------------
    A synonym is an alias for any table, view, materialized view, sequence, procedure, function, or package.
    ----------------------

    You can, although, create a synonym for a table/view on remote database using a DBLink.


    Originally posted by zulu99
    Hi All

    I am trying to create a synonym for database link

    using

    create synonym test for testdb.us.oracle.com;
    *

    ERROR at line 1:
    ORA-00933: SQL command not properly ended



    Is it that we cannot create a synonym for a database link
    or is there something misssing in the above SQL


    Rgrds
    Oracle can do wonders !

  3. #3
    Join Date
    Dec 2003
    Posts
    6
    Hi

    it is missing with @ symbol
    if it is at remote location u hv to use @ symbol


    E.g)
    CREATE PUBLIC SYNONYM emp_table
    FOR oe.employees@remote.us.oracle.com;


    bye

  4. #4
    Join Date
    Dec 2003
    Posts
    6
    Hi

    it is missing with @ symbol
    if it is at remote location u hv to use @ symbol


    E.g)
    CREATE PUBLIC SYNONYM emp_table
    FOR oe.employees@remote.us.oracle.com;


    bye

Posting Permissions

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