Message-Id: <10701.123637@fatcity.com> From: "Manasa Rao" Date: Tue, 05 Dec 2000 12:48:28 -0000 Subject: Re: Exp/Imp problem. All, At my new work site, the Exp/Imp utility is not working. When I say exp it does nothing. They say that the server needs to be cleaned up. For now, how do I make the Exp/Imp utility work? Could I just re-install the utility separately by doing custom installation? If so, would it change the existing database in any way. Appreciate your suggestions. regards Manasa. >From: "Rachel Carmichael" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Re: Privileges problem. >Date: Mon, 04 Dec 2000 12:45:57 -0800 > >did you create a public synonym for set_role? > >otherwise have them execute it as .set_role > > >>From: "Manasa Rao" >>Reply-To: ORACLE-L@fatcity.com >>To: Multiple recipients of list ORACLE-L >>Subject: Privileges problem. >>Date: Mon, 04 Dec 2000 10:00:46 -0800 >> >>All, >> >>I have created some procedures and gave >>grant execute on set_role to public; >>which should let them execute the procedure. But the other user is not >>able >>to EXECUTE the procedure-set_role in my schema. They get the following >>error >>below. >> >>Appreciate any suggestions. >> >>Thanks >>Radhika. >> >>12:54:54 SQL> execute set_role(1, NULL, NULL); >>BEGIN set_role(1, NULL, NULL); END; >> >> * >>ERROR at line 1: >>ORA-06550: line 1, column 7: >>PLS-00201: identifier 'SET_ROLE' must be declared >>ORA-06550: line 1, column 7: >>PL/SQL: Statement ignored >>_____________________________________________________________________________________ >>Get more from the Web. FREE MSN Explorer download : >>http://explorer.msn.com >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Manasa Rao >> INET: rao_manasa@hotmail.com >> >>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: ListGuru@fatcity.com (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). > >_____________________________________________________________________________________ >Get more from the Web. FREE MSN Explorer download : >http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > INET: carmichr@hotmail.com > >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: ListGuru@fatcity.com (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). _____________________________________________________________________________________