Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exp/Imp problem.

Re: Exp/Imp problem.

From: Manasa Rao <rao_manasa_at_hotmail.com>
Date: Tue, 05 Dec 2000 12:48:28 -0000
Message-Id: <10701.123637@fatcity.com>


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" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 <owner>.set_role
>
>
>>From: "Manasa Rao" <rao_manasa_at_hotmail.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>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_at_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_at_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_at_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_at_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).


Received on Tue Dec 05 2000 - 06:48:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US