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

Answer Posted / suman

DROP USER USERNAME CASCADE;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you best determine why your MVIEW couldn't FAST REFRESH?

1833


what is asm?

607


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

583


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2063


What is dcl? : sql server DBA

650






when does an alert gets signaled?

582


how can you implement fine-grained auditing?

606


what do you understand by fine-grained auditing?

633


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1846


Why would you call update statistics? : sql server DBA

579


what is a user-defined lock?

590


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

1747


What purpose does the model database server? : sql server DBA

629


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1726


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1690