database - how to distribute oracle databse -


i want distribute oracle database 11g on 3 servers don't know how start. read documents :

http://docs.oracle.com/cd/b10501_01/server.920/a96521/ds_concepts.htm

and others same . didn't find how start. want start document how start distribute oracle , contains :

1) how install oracle distribution

2) how link them rules

3) how query in java application

according comment, want integrate several existing system. in case, easiest approach database links:

there no special installation involved. add remote databases tnsnames.ora know how connect each other.

then create database link, e.g.:

create database link orlando    connect joe    identified mysecret    using orcl33b; 

now can query data (or insert or update):

select a.name, b.total_amt person join sales@orlando b a.id = b.cust_id; 

sales@orlando refers remote table sales in remote orlando database.

there different types of database links (regarding authentication, sharing , availability in other schema). you'll need check best serves you.


Comments

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

Nuget pack csproj using nuspec -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -