dblink db Name

Posted on 2011-05-03
Last Modified: 2012-05-11
Hi dears,

I create an db link on oracle 10g with Toad and  i receive the confirmation Message : Database Link Created. Would you like to test it now ?

I Answer with Yes and I receive another Confirmation with :

Link Name
DB Name
DB Version

The connection is OK, but i have an strange Name on DB NAME : dumpdb.domainname

Where Oracle comes to this DB Name ?

db_file_name_convert =dumpdb, DF
db_unique _name=DF

Question by:Postbank
    LVL 73

    Accepted Solution

    that's the name it gets from

    LVL 73

    Assisted Solution

    in the menu Database -> Spool SQL -> Spool SQL to Screen

    then click the Lightning Bolt "Test Database LInk" icon

    you'll see the SQL exectuted by Toad during its test
    LVL 73

    Expert Comment

    I see this is your first question on EE.

    Welcome aboard!

    Note, you'll receive more and faster responses if you don't lower the point values to the minimum.  Also, selecting more than one zone (if applicable) will help by sending your question to more people.


    Author Comment

    Thank you :)

    OK, i will do it on my next Question. I have t Inform me about this Points.

    To my answer. Global Name is DF, why he writes dumpdb ?
    LVL 73

    Expert Comment

    Toad will display whatever the sql statement returns.

    If you execute the same statement yourself you should see the same results.  If you don't, then Toad is doing something odd and you'll have to contact Quest support
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    See if the domain name is being added from your sqlnet.ora file:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    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

    18 Experts available now in Live!

    Get 1:1 Help Now