OraFAQ Forum: Forms » import access data to oracle

Home » Developer & Programmer » Forms » import access data to oracle (oracle, 10g, windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import access data to oracle [message #458883]

Wed, 02 June 2010 05:52

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

i have followed the Maaher's message and work on it step by step.

i got it from odbc#msg_286922

but at last, when i create db link then it show below:

SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"

SQL> create database LINK orafaccess using 'ORAFACCESS';

Database link created.

SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD

SQL>

here global database name : apex.apex.com

please some help me.

Yeahia

Report message to a moderator

Re: import access data to oracle [message #458885 is a reply to message #458883]

Wed, 02 June 2010 06:03

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to create a database link using 'orafaccess.apex.com'? Or perhaps "orafaccess.ho.world" (I didn't quite understand which is which).

Report message to a moderator

Re: import access data to oracle [message #458889 is a reply to message #458885]

Wed, 02 June 2010 06:49

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

no, i never try to create a database link using 'orafaccess.apex.com' or "orafaccess.ho.world"

Report message to a moderator

Re: import access data to oracle [message #458902 is a reply to message #458889]

Wed, 02 June 2010 08:20

John Watson
Messages: 8944
Registered: January 2010
Location: Global Village

Senior Member

You have the parameter global_names set to TRUE. You must set it to FALSE if the name of the link is not the same as the global name, or the link won't work.

Report message to a moderator

Re: import access data to oracle [message #458991 is a reply to message #458902]

Wed, 02 June 2010 18:08

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi dear

try this

create public database link orafaccess using 'ORAFACCESS'

and check database link weither is created or not

select 'x' from dual@orafaccess;

oh yah you have to configure tnsname.ora also

feel free for further questionaing

Report message to a moderator

Re: import access data to oracle [message #459017 is a reply to message #458991]

Thu, 03 June 2010 00:45

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

i use create public database link ....
still the same error display.
yes i have configured the tnsnames.ora propertly as per instruction of Maaher

[Updated on: Thu, 03 June 2010 00:46]

Report message to a moderator

Re: import access data to oracle [message #459019 is a reply to message #458902]

Thu, 03 June 2010 00:48

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

after this the same error dispaly:

SQL> create public database LINK orafaccess using 'ORAFACCESS';

Database link created.

SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD

where should i change the parameter? please explain. should i restart the database after change?
regards.

[Updated on: Thu, 03 June 2010 01:11]

Report message to a moderator

Re: import access data to oracle [message #459034 is a reply to message #459019]

Thu, 03 June 2010 02:09

John Watson
Messages: 8944
Registered: January 2010
Location: Global Village

Senior Member

You need to look in the documentation. The "Reference" will tell you about the global_names parameter, and the "SQL Reference" will give you the syntax of the ALTER SYSTEM command to change it. You also need to look up the CREATE DATABASE LINK command, because you haven't specified the schema to which the link should connect.

Report message to a moderator