Creating Database Links on Oracle 10.2.0.1 results in the string REGRESS.RDBMS.DEV.US.ORACLE.COM being appended to the link name.
 
SUSE Linux 9.3 Prof x86 on Standalone Notebook
host name   linux.site
Oracle DB 10.2.0.1 enterprise
 
SQLNET.ORA   NAMES.DIRECTORY_PATH = ( TNSNAMES, EZCONNECT )
 
TNSNAMES.ORA has following entry
 
     DB1 = (.....
             CONNECT_DATA 0
               ( SERVER = DEDICATED
                  SERVICE_NAME = db1 )
 
  DB Parameters:  
 
    global_name   : false
    db_name       : db1
    service_names : db1
 
CREATE DATABASE LINK TEST CONNECT TO "SCOTT"
          USING 'db1'
 
This incorrect result is achieved whether the link is creared via SQLPlus or another tool such as OEM
 
**** HOWEVER on Oracle 10.1.0.3 installed with exactly the same parameters as for the above case the Link is created correctly as TEST.
 
This causes my installation of Oracle Warehouse Builder 10.1.0.4 to function Incorreclty on the Oracle 10.2.0.1 database.
In Warehouse builder when you need to create a Database Link for an Oracle Schema Location , it reports an Error that the database Link Name cannot exceed 40 characters.
However Warehouse Builder creates the database link on the Database Server in the incorrect format then tries to store this same link in its Meta Data Table and fails because the Meta Data Table column only allows a length of 40 wheras the Oracle DataDictionary allows objects to have a length of 120.
 
This shows the Meta Data tables of Warehouse builder do not correnspond to the 10G data dictionary meta definitions
 
If anyone knows a way to create database links in 10.2.0.1 without this annoying
REGRESS.RDBMS.DEV.US.ORACLE.COM , i would really like to know
 
Regards
Russell
 
 



   
---------------------------------
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.