Home > Default > I should create a new database link to an AS/400 server but i m rookie!!

I should create a new database link to an AS/400 server but i m rookie!!

November 30Hits:0
Advertisement
İ have an oracle 10g DB server.İ need get some of data from AS/400 DB on other location and put them all to my oracle server.İ should create a database link between oracle server and AS400 DB but how will i realize that event.in oracle 10g enterprise manager console i choose administration-database link-create database link.At this step how could i fill the requirement.Which format should i use.
General
* Name:????????     (should i type the AS400 IP?????)
* Net Service Name:????????     (what should i fill)
Public - This database link is available to all users.
Connected User:
Current User
Fixed User
Username     
Password     
Confirm Password     
thanks for all as now

Answers

İ have an oracle 10g DB server.İ need get some of data from AS/400 DB on other location and put them all to my oracle server.İ should create a database link between oracle server and AS400 DB but how will i realize that event.in oracle 10g enterprise manager console i choose administration-database link-create database link.At this step how could i fill the requirement.Which format should i use.
General
* Name:????????     (should i type the AS400 IP?????)
* Net Service Name:????????     (what should i fill)
Public - This database link is available to all users.
Connected User:
Current User
Fixed User
Username     
Password     
Confirm Password     
thanks for all as now

Read other 3 answers

Tags:

Related Articles

  • I should create a new database link to an AS/400 server but i m rookie!!November 30

    İ have an oracle 10g DB server.İ need get some of data from AS/400 DB on other location and put them all to my oracle server.İ should create a database link between oracle server and AS400 DB but how will i realize that event.in oracle 10g enterprise

  • Creating Database Link from Oracle to SQL ServerNovember 30

    I am trying to create a database link from Oracle to SQL Server, and the documentation is about as clear as mud to me. Can anyone send me clear instructions on exactly what I need to do? What needs to be in tnsnames.ora and listener.ora files? Is the

  • How to create database link between oracle and SQL ServerNovember 30

    Hello Everyone, Here i have Oracle Database 9i and SQL Server 2005 databases. I have some tables in sql server db and i want to access from Oracle. How to create a database link between these two servers Thanks,Thanks for Everyone, I was struggle wit

  • How to create database link from oracle to sql serverNovember 30

    Please help with how to create database link from oracle to sql server Best regards, VishalPlease help with how to create database link from oracle to sql server Best regards, Vishal Hi Vishal, I found a lof of information regarding how to create a d

  • Creation of database link from oracle to sql server 2000November 30

    Hi I need to create a database link from oracle to sql server 2000.Assuming your Oracle database is running on Windows, you can set up a database link using ODBC using Heterogeneous Services and Generic Connectivity, but there are some functional lim

  • Database link between oracle and sql serverNovember 30

    dear all, i m a newbie to oracle and i need your help to know how to create a database link between oracle and sql server.my oracle version 10.2.0.3 and platform is redhat linux 5.7.your help appreciated. thanks in advance.[[email protected] ~]$ rpm -

  • Issue while creating location with database linkOctober 11

    Hi all, I am using OWB 10.2.0.4.0 (same Oracle DB version). I am trying to create a location using a database link. When I select the location which the database link is located (From location drop-down list), I face the following error. > ENV0036: T

  • Create View from Database Links - QuestionOctober 11

    Question I'm missing something simple. I'm trying to create a view, from a Database Link. CREATE VIEW view_name AS SELECT a.* FROM [email protected] a; When I run this in the SQL Commands window. I get this error message. ORA-00933: SQL command

  • Creating user using database linkNovember 30

    Hi I have 11g installed on one of the server I have created the database link BUGAU to bugau.us.oracle.com link works fine select * from [email protected]"Bugau" gives the expected result I need run the below statement from my server using the dblink.but n

  • Remote procedures created on Private Database LinksNovember 30

    How to grant access to role on the private synonym created in a schema for the remote procedure with private Database links. We have converted the public database links to private. Plz suggest me how to access the remote procedures and grant access t

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.499 s.