IntelliJ Java IDE
The moose likes Oracle/OAS and the fly likes Setting a database(user) to single user mode? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "Setting a database(user) to single user mode?" Watch "Setting a database(user) to single user mode?" New topic
Author

Setting a database(user) to single user mode?

Amit Paleja
Greenhorn

Joined: Apr 21, 2007
Posts: 7

Hi

I want to set a particular user (database) to single user mode so that only one user at a time can access it. This is required so as to import data from another user on the same server after which i wish to revert the user to multi user mode.

I tried to achieve this with the following query but in vain:
ALTER SYSTEM ENABLE RESTRICTED SESSION

This sets the entire database server to single user mode and not the user (database) that I want to (the one that am currently connected to).

Is there a way to achieve this?

Amit


The dictionary is the only place where success comes before work. -Vince Lombardi.
 
IntelliJ Java IDE
 
subject: Setting a database(user) to single user mode?
 
Threads others viewed
nx:All of URLy Bird1.1.3 about record lock
regarding mode
Does the server program of the system in remote mode supports local mode?
threadsafe locking
Map or Hashtable
developer file tools

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture