import access data to oracle [message #458883] |
Wed, 02 June 2010 05:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
|
Re: import access data to oracle [message #459019 is a reply to message #458902] |
Thu, 03 June 2010 00:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|
|