Hi Folks , Somebody tell me I am not insane...please..!! The problem is this... As usual Everybody else except DBA ( me..) decided and designed a program to create user in other database using a procedure thru db_link. Example. The programme exists in database A. When they want they have to execute a procedure under sys schema in Database B to create a user in database B and they have to be able to pass username and password to teh procedure.
well...God had other plans and they are getting ORA - 2064 "distributed operation not supported" NOw I am stuck with troubleshooting. Has anybody seen and/or used anything like this ? ANy pointer is welcome and would be appreciated. TIA Cheers RS __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).