Re: The light dawns - public synonym called SYS - how to drop?
From: gazzag <gareth_at_jamms.org>
Date: Thu, 3 Jul 2008 09:04:54 -0700 (PDT)
Message-ID: <bb06449b-c724-4378-a044-fff6092a4b84@w7g2000hsa.googlegroups.com>
Date: Thu, 3 Jul 2008 09:04:54 -0700 (PDT)
Message-ID: <bb06449b-c724-4378-a044-fff6092a4b84@w7g2000hsa.googlegroups.com>
On 3 Jul, 16:50, gazzag <gar..._at_jamms.org> wrote:
> Ouch! What about:
>
> DROP PUBLIC SYNONYM "PUBLIC.SYS";
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
Ignore previous post. I've just tried it on a test database and the same error is returned. I too now have a kippered database :)
If the database in question is in ARCHIVELOG mode, would a PITR be possible?
HTH -g Received on Thu Jul 03 2008 - 11:04:54 CDT