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

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 - 09:24:18 CST