now one user in online.now i want drop him..how do u drop him?
Answer Posted / raja
DROP USER 'USER_NAME' CASCADE;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where do you find the default index fill factor and how to change it? : sql server DBA
how does an oracle clusterware manage crs resources?
what are the performance views in an oracle rac environment?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is the last version,the release date of that version and fix pack of ibm db2 udb?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Query processing is slow(eg select query)how will u solve that
who owns the operating system files created by the utl_file package?
what do you understand by flashback feature of oracle?
What are the operating modes in which database mirroring runs? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a correlated sub-query? : sql server DBA