- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle question
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 04:40 AM
тАО09-15-2003 04:40 AM
Currently I have two users on the same hp-ux box who use the same database. What I would like to have is that user a connects to the same database as the other user but that user a is connected to another segment or tablespace than user b. By doing this user a will be able to make changes to his part of the database while the other user won't notice it. I have to use this kind of solution because the ORACLE_SID is hardcoded in a lot of programs and it is impossible to change it.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 11:20 AM
тАО09-15-2003 11:20 AM
Re: oracle question
user a and b are unix logins?
What about giving them different Oracle users
and each Oracle User a different default tablespace. What user are the programs using?
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 11:21 AM
тАО09-15-2003 11:21 AM
Re: oracle question
do both these users have the same oracle id?
or are there different oracle IDs owning different tables?
If it's the second case - they will be independent of each other - you can separate their objects into different tablespaces - but even if you don't, they would each have different tables - i.e. a.tab1 b.tab1 would be different tables.
If they both connect as the same oracle user - or if they both update tables owned by the same user - they can't be separated.
you can give an oracle user its own default tablespace if that helps
create user billy identified by goat default tablespace BARN temporary tablespace TEMP
quota unlimited on BARN;
create user chicken identified by little default tablespace COOP temporary tablespace TEMP
quota unlimited on COOP;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 06:23 PM
тАО09-15-2003 06:23 PM
SolutionFrom you question I understand that you have users A and user B who are two UNIX accounts. These two users A & B logon to the same database. And whne user A is modifying any tables / data user B should not be disturbed / unaware. If this is what you wanted then you can do the following.
Define user A and user B in the oracle database as two different users with different tablespaces as their default tablespaces. then give grants and quotas on the respective tablespaces.
Eg:.
Create user A identifed by
default tablespace
ALTER USER
Create user B identifed by
default tablespace
ALTER USER
Now when the user A logon to the database and creates any objects then they will be in tablespace-A and likewise with the user B they will be in tablepsace B.
I hope this helps.
IA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 07:18 PM
тАО09-15-2003 07:18 PM
Re: oracle question
Over the long term however, if both users have dba rights, they can still step on each others data.
If you decide to examine your system to scope out the project of different instances, you can start as follows:
find / -exec ls -1 '$ORACLE_SID' {} \;
This will at least get you a list of the number of scripts that have the SID hard coded.
I'm sure some of the scripts will have to be replicated, and some will have to be modified. sed is a good utility for doing that.
I'm attacing a script that lets you read a filelist and change contents.
With the right tools, the job might not be as big as you think.
From a purely arrogant(sorry about that) IT view, oracle data that is unrelated, and not part of the same application doesn't belong in the same instance. There are lots reasons, including the need to someday tune the database for performance that factor into that decision.
regards,
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 07:33 PM
тАО09-15-2003 07:33 PM
Re: oracle question
SEP> From a purely arrogant(sorry about that) IT view, oracle data that is unrelated, and not part of the same application doesn't belong in the same instance.
yabutt... Oracle has a lot of 'stuff' like 200 MB system space, 5 - 10 background processes, REDO, UNDO, TEMP, that can all readily be shared and make for a MUCH more efficient total system usage.
I can not help but think that the targetted multiple users as described are going to be 'modest' users with say less than 30 tables and less than 1GB data. I have _nothing_ to base this on other then the tone of the question, so i may well be wrong. If I'm write though, then they'll happily live in the same database, even though that is not 'clean'.
fwiw,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 07:58 PM
тАО09-15-2003 07:58 PM
Re: oracle question
By this way each user can work independently as the unix login.
Make sure that you do not give additional rights to the users except for creating/manipulating their own schema.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 07:58 PM
тАО09-15-2003 07:58 PM
Re: oracle question
By this way each user can work independently as the unix login.
Make sure that you do not give additional rights to the users except for creating/manipulating their own schema.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2003 08:29 PM
тАО09-15-2003 08:29 PM
Re: oracle question
one way will be to create two users each one having "create table" priviledge.
You can then create the tables in each user's schema which will be completely independent of each other.
The tablespace can be the same or different and they will not affect anyone of them.
Are you using public synonyms?
if not, that would be easy to keep two version of the "data".
If you want table level restrictions, you can grant and revoke priviledges accordingly.
All these can be done irrespective of the current setting for ORACLE_SID.
hope this helps!
regards
Yogeeraj