Hi mm kk,
your post is quite general.., I've an experienced for creating those such of
thing a couple of years ago :). However, let me try to solve your inquery.
There are several steps required for creating a multiple database links. I
assumed here, you want to create a view in database 'X' and get the data from
various databases, for example 'A', 'B','C'. First of all, you need to ensure
that the connection string to those databases have been identified in database
'X' by using tnsnames.ora file and you can logon to those databases using the
authorised user. Secondly, please create the database link for each database
using the following syntax :
CREATE DATABASE LINK 'DB_Link_name' CONNECT TO 'admin_remote_username'
IDENTIFIED BY 'password_admin_remote' USING
'ConnectionStringRegisteredInTnsnamesOra';
For example: The database link name is TestLink, connection string to
database 'A' is 'JSDBA' and the admin user in database A is admin, the the
syntax should look like:
CREATE DATABASE LINK TestLink CONNECT TO admin IDENTIFIED BY admin USING
JSDBA;
The same syntax would be applicable if you need to create a database link to
other databases. Then you will be able to create a view for selecting data from
multiple table and from multiple databases by adding the database link name in
every table used in the query. for example:
CREATE VIEW TestView AS
SELECT last_name, salary*12 annual_salary
FROM [EMAIL PROTECTED]
WHERE department_id = 'xx';
Please noted, as far as i knew (since i did not used Oracle for almost 2
years), the DDL operational (Create, Update, Delete) only applicable in local
database, not in remote databases.
Hope this can help you.
Cheers,
Agus
k <[EMAIL PROTECTED]> wrote:
i want to create db link to create view that query from multiple db
---------------------------------
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
[Non-text portions of this message have been removed]
