create dataabse link in someone else's schema

Posted on 2011-10-11
Last Modified: 2012-05-12
Hi guys,
There is any way to create dataabse link in someone else's schema
Question by:nirvairghuman
    LVL 76

    Accepted Solution

    On mobile and cannot try it but try adding the schema:

    Create database link other_schema.link_name ...
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    Sorry but now that I am where I can look into it, you cannot:

    Restriction on Creating Database Links You cannot create a database link in another user's schema, and you cannot qualify dblink with the name of a schema.
    LVL 7

    Expert Comment

    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)

    Two things wrong with that post:
    1: That is MySQL not Oracle.
    2: It is the syntax for 'create view', not 'create database link'.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now