Hi Raj,

You are very welcome. Like Irfan said sometime back, this forum is where all
our gratitude needs to be shown. Glad to be a part of this great group.

Best Regards,
Dhilip Ranganathan.

-----Original Message-----
From: Oracle User [mailto:[Email Address Removed] Thursday, March 28, 2002 11:17 AM
To: [Email Address Removed] [Email Address Removed] RE: init.ora interesting?


Hi

Thanks many to all those who helped me in trouble shooting the problem. The
server is in a different location and the actual DBA is on vacation. The
developer had asked me to trouble shoot in one database while the problem
was in the other database. The RBS were not listed in the init.ora.

THanks again and thanks to Dilip.

Raj


>From: "Ranganathan, Dhilip" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: Drop Synonyms Problem
>Date: Thu, 28 Mar 2002 11:06:54 -0600
>
>Hi,
>
>Your drop script uses 'DROP SYNONYM ...' but the output says 'DROP PUBLIC
>SYNONYM ....'. Is this just a typo or is there a syntax issue ???
>
>Dhilip Ranganathan.
>
>-----Original Message-----
>From: Patrick McKay [mailto:[Email Address Removed] Thursday, March 28, 2002 10:06 AM
>To: LazyDBA.com Discussion
>Subject: Re: Drop Synonyms Problem
>
>
>
>Does the user have the DROP PUBLIC SYNONYM privilege?
>
>I also think your create synonym statement should be:
>
>CREATE SYNONYM AVAILABILITY_GROUP FOR APPUSER.AVAILABILITY_GROUP
>
>
>InternetDBA- Oracle DBA via your browser!
>
>Free / trial versions available at:
>
>http://www.theNetDBA.com <http://www.theNetDBA.com>
>
>
>
>
>
> >From: "McKay, Woodrow (DST-CLT)"
> >To: "LazyDBA.com Discussion"
> >Subject: Drop Synonyms Problem
> >Date: Thu, 28 Mar 2002 09:52:11 -0500
> >
> >Hello all,
> >
> >I trying to write a SQL Plus script to drop all current synonyms for
>APPUSER
> >and recreate them from the newly loaded set of tables owned by DSTI002.
> >
> >I spool the following to separate files:
> >
> >--to create synonyms
> >
> >select 'CREATE SYNONYM APPUSER.' || OBJECT_NAME || ' FOR ' || OBJECT_NAME
>||
> >' ; ' from dba_objects where object_type in ('TABLE','VIEW') and OWNER =
> >'DSTI002';
> >
> >--to drop synonyms:
> >
> >select 'DROP SYNONYM ' || SYNONYM_NAME || ';' from dba_synonyms where
>owner
>
> >= 'APPUSER';
> >
> >I then run the drop script and then the create script but get the
>following
>
> >outputs:
> >
> >DROP PUBLIC SYNONYM AVAILABILITY_GROUP
> > *
> >ERROR at line 1:
> >ORA-01434: private synonym to be dropped does not exist
> >
> >CREATE SYNONYM APPUSER.AVAILABILITY_GROUP FOR AVAILABILITY_GROUP
> > *
> >ERROR at line 1:
> >ORA-00955: name is already used by an existing object
> >
> >Can someone tell me what is going on here and how I can fix it?
> >
> >Thanks,
> >
> >Woody
>
> _____
>
>Chat with friends online, try MSN Messenger: Click Here
><http://g.msn.com/1HM305301/11>
>-------- Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a
>blank email to oracledba-[Email Address Removed] To subscribe: send a blank
>email to oracledba-[Email Address Removed] Visit the list archive:
>http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about
>http://www.farAwayJobs.com By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
Oracle LazyDBA home page