now one user in online.now i want drop him..how do u drop him?
Answers were Sorted based on User's Feedback
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 |
Answer / vikram
Remove from masseger or else tell him logout fom massenger.
Is This Answer Correct ? | 2 Yes | 2 No |
What is the difference between LMT & DLT?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is a crs resource?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Where in the Oracle directory tree structure are audit traces placed?
what is difference between user managed backup and rman backup?
Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris
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?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?