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;

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2066

---

What are the commands used in dcl? : sql server DBA

1076

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1119

---

what is the role of dip user in our database?

2417

---

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

2641

---

Which autogrowth database setting is good? : sql server DBA

1163

---

Query processing is slow(eg select query)how will u solve that

7923

---

Why does Oracle not permit the use of PCTUSED with indexes?

2947

---

Explain materialized views and how they are used.

2445

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1075

---

what do you understand by fine-grained auditing?

1062

---

how can you connect from 10g user to 11g user??

2117

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1083

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

999

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1000

---