Answer / 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;

Answer / raja

DROP USER 'USER_NAME' CASCADE;

Answer / vikram

Remove from masseger or else tell him logout fom massenger.

Answer / suman

DROP USER USERNAME CASCADE;

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---