Interested to Buy Any Domain ? << Click Here >> for more details...
now one user in online.now i want drop him..how do u drop him?
- 4 Answers
- 6750 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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the default port no on which sql server listens? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is the use of recording information about current session?
what is logical system in sap basis
What is dbcc? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Why would you use sql agent? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you create a user-defined lock?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where would you look for errors from the database engine?
what is grd?
