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

Home -> Community -> Usenet -> c.d.o.server -> Re: "public synonym to be dropped does not exist" ?!?

Re: "public synonym to be dropped does not exist" ?!?

From: Leonard F Clark <lfc_at_zoom.co.uk>
Date: Sun, 25 Feb 2001 20:16:12 GMT
Message-ID: <3a9967d3.5872494@125.0.0.1>

In fact, my definition of a DBA is "someone who knows which error messages to ignore"!<g>. Keep at it, Volkmar.

Len

>When oracle runs these scripts it first drops the object it is going to
>create for example :
> drop table table1;
> create table table1........;
>
>Oracle replies
> error at line 1 table table1 does not exist
> table created
>
>This is a method of ensuring the object can be created, if you had created
>such a object and oracle tried to create one with the same name, the
>statement would fail and whatever you were installing would fail also.
>
>In short this is normal
>
>
>
>
>"vrw" <linux4me2000_at_netscape.com> wrote in message
>news:97b6e4$a2u$1_at_news5.svr.pol.co.uk...
>> Hello everyone,
>> As I'm writing this, Oracle 8.1.7 EE is creating a "default" database on
 my
>> Linux system. Things are moving along, but every block of 'Statement
>> processed' messages is preceded by "public synonym to be dropped does not
>> exist". (Then, at the end it says DROP PUBLIC SYNONYM
>> whatever-the-current-section-name-is.)
>> What does this mean ? Since my Oracle Admin knowledge is still in its
>> infancy (well, non-existant @ this point, to be honest...), I need someone
>> to give me a clue as to what's going on.
>>
>> Thanks a lot in advance,
>>
>> Regards,
>>
>> Volkmar
>>
>
>
Received on Sun Feb 25 2001 - 14:16:12 CST

Original text of this message

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