now one user in online.now i want drop him..how do u drop him?
- 4 Answers
- 5144 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kittu
Hi,
First query
select username, sid#, serial from v$session where
username='ur_username';
if rows are get selected, then kill the process, by issuing
following statement:
alter system kill session 'sid, serial#';
after that issue the following statement:
drop user username cascade;
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what are the differences of where and if in SAS?
how can you communicate with operating system files from oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Can you redefine a table online?
what is the use of ocr?
What is the default fill factor value? : sql server DBA
how can you implement fine-grained auditing?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is a crs resource?
How would you go about verifying the network name that the local_listener is currently using?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
