my guess is the public synonym is still there, grant select on dual to
public.
if the synonym isnot there recreate it also.
joe
>>> shirish_at_rolta.com 06/19/01 01:51PM
>>>hii accidentally dropped duel table from sys..then
recreated it.now when i am using rman during running the catrman.sql for
recovery_catalogit is flashing errorselect '08.00.05' from
dual*ERROR at line 2:ORA-00942: table or view does not
existu'r help is highly appreciatedShirish Khapre, SE Rolta
India Ltd.Off Ph No. (+91) (022) 8326666,8262222,8300568Ext'n
2730Minds are like parachutes. They only function when they are
open-- Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Shirish
Khapre INET: shirish_at_rolta.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Jun 19 2001 - 12:05:59 CDT
