-
accessing objects between schemas
Hi all
1. If you are running 2 instances on the same machine, how would a user/dba in one instance access an object in a schema of the other instance? My 2 instances are ora1 and ora2, ora1dba1 (of ora1) wants to access a table mat_npcb of the or81502 schema in ora2.
2. What are the advantages of using a password file and when should one use one?
Thanks
-
you put username in front of object_name
-
database links is what you need.
Password file is used for remote logins.
-
How do I create a database link between two instances? Could not find this info by searching the posts. Once the link is established, can I use it to grant priveleges on the objects in the schemas of each instance?
-
search the forum for create database link
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|