This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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?
The dictionary is the only place where success comes before work. -Vince Lombardi.