I create a user like KUMAR'S
while dorping user ,,,this user not deleted...
and its give some errors
please give solution....
oh really - thanks for the detailed post with all the messages and errors
in case the sarcasm didn't translate, you need to post more details including the exact error message you're getting.
Dear gurus please help enlighten us using only your superior wisdom and crystal ball.
Assistance is Futile...
"while dorping user "
Is the error something like 'Unknown command beginning DORP USER' ?
my user account is like kumar's
while droping user in oracle...its give the following error message...
ORA-00604: error occurred at recursive SQL level 1
ORA-00933: SQL command not properly ended
ORA-06512: at line 7
Error that you see is probably due to bug 2367152.
Check if user MDSYS exists on your database. If you are not using interMedia, then you can just drop user mdsys.
After you drop this user you can drop user kumar's :
drop user "kumar's";
Thank you very much.....
its working....but, i've some doubt by using above scenario....
while droping user mdsys account...i fear about is there any problem occur in future...since my oracle server in some remote machine....
please give if any other solution....
You could use workaround which is decribed on metalink under doc id : 531837.999
Click Here to Expand Forum to Full Width