Create separate tablespaces...separate users..how many u want..
Create the objects in respective users...
In single database u can have 1000 of users..with similar object name.
Thanks and Regards
KempegowdA....
Cognizant Technology Solutions
Ph : 91 44 2811 3063 Ext:-2249
Vnet -- 42249
Discipline is the bridge between goals and accomplishment..- Jim Rohn
-----Original Message-----
From: Mitchell Baldwin [mailto:Mitchell.[Email Address Removed]
Sent: Friday, January 30, 2004 4:53 PM
To: LazyDBA.com Discussion
Subject: Clarify ?..
Hi All
I have a request to create a development environment for our Clarify developers, and would like to ask the question about the login sequence for clarify (2 tier mode).
I don't want the overhead of having multiple instances so therefore need to create multiple users with there own set of objects.
So has anyone achieved this set-up within a singular database, and how was it achieved without SA ?.
Any ideas/tips would be much appreciated.
TIA
Mitch
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
--------
Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Oracle LazyDBA home page