Re: create or replace

From: Dave <x_at_x.com>
Date: Mon, 27 Dec 2004 11:46:51 GMT
Message-ID: <LCSzd.7585$Ar5.1487@text.news.blueyonder.co.uk>

"Christopher Jung" <cjung_at_blank.com> wrote in message news:Y1Lzd.3592$Fl5.3026_at_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
>
>

my bad (but 9i has been around fot years:-)) Received on Mon Dec 27 2004 - 05:46:51 CST