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

Question Posted / rajarengaiyan

4 Answers
6473 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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;

Is This Answer Correct ?

9 Yes

0 No

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

Answer / raja

DROP USER 'USER_NAME' CASCADE;

Is This Answer Correct ?

4 Yes

3 No

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

Answer / vikram

Remove from masseger or else tell him logout fom massenger.

Is This Answer Correct ?

2 Yes

2 No

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

Answer / suman

DROP USER USERNAME CASCADE;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers

What is a correlated sub-query? : sql server DBA

0 Answers

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

0 Answers

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 is meant by gateway

1 Answers IBM,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

Explain CREATE DATABASE syntax?

2 Answers

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

what is the difference between db2start command and start database manager command?

1 Answers

For more DB Administration Interview Questions Click Here