Re: create or replace

From: Christopher Jung <cjung_at_blank.com>
Date: Mon, 27 Dec 2004 03:09:44 GMT
Message-ID: <Y1Lzd.3592$Fl5.3026@newssvr31.news.prodigy.com>

Gosh create or replace syntax for synonyms looks new to me. Well, I guess 9 isn't new anymore.

SQL> select version from v$instance ;

VERSION

---

9.2.0.1.0

SQL> create or replace synonym testx for testy;

Synonym created.
-- in another db
SQL> select version from v$instance ;

VERSION

---

8.1.7.1.0

SQL> create or replace synonym testx for testy;  create or replace synonym testx for testy

                   *

ERROR at line 1:
ORA-00922: missing or invalid option

SQL> "Christopher Jung" <cjung_at_blank.com> wrote in message news:nNKzd.3591$Ij5.2382_at_newssvr31.news.prodigy.com...
> Ok, then I never noticed it until 9.
>
> I do like in general how Sybase allows you to test if an object exists
> before dropping it, so you can avoid spurious errors.
>
> "Dave" <x_at_x.com> wrote in message
> news:qjJzd.7474$Ar5.2313_at_text.news.blueyonder.co.uk...
> >
> > "Christopher Jung" <cjung_at_blank.com> wrote in message
> > news:vFIzd.3708$Y8.3431_at_newssvr17.news.prodigy.com...
> > > Synonyms, new in some version of 9 I think?
> > >
> >
> > been there since forever, years and years
> >
> >
>
>
Received on Sun Dec 26 2004 - 21:09:44 CST