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;

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

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

0 Answers   iGate,

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

why we use cursors

1 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

What is dbcc? : sql server DBA

0 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---