Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / rajarengaiyan

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

why we use cursors

1 Answers  

what is grd?

0 Answers   Oracle,

How many packages we have in db

1 Answers   Tesco,

what is the use of recording information about current session?

0 Answers   Oracle,

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

how can you record information about current session?

0 Answers   Oracle,

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 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 purpose of catlaog in oracle rman?

2 Answers   Value Labs,

Give two examples of referential integrity constraints.

2 Answers  

For more DB Administration Interview Questions Click Here
Categories