Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: The light d...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 10 Topic 16845 of 17248
Post > Topic >>

Re: The light dawns - public synonym called SYS - how to drop?

by gazzag <gareth@[EMAIL PROTECTED] > Jul 3, 2008 at 09:04 AM

On 3 Jul, 16:50, gazzag <gar...@[EMAIL PROTECTED]
> wrote:
> Ouch! =A0What 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
 




 10 Posts in Topic:
The light dawns - public synonym called SYS - how to drop?
jeremy <jeremy0505@[EM  2008-07-03 08:26:56 
Re: The light dawns - public synonym called SYS - how to drop?
gazzag <gareth@[EMAIL   2008-07-03 08:50:46 
Re: The light dawns - public synonym called SYS - how to drop?
gazzag <gareth@[EMAIL   2008-07-03 09:04:54 
Re: The light dawns - public synonym called SYS - how to drop?
jeremy <jeremy0505@[EM  2008-07-03 09:08:21 
Re: The light dawns - public synonym called SYS - how to drop?
Mark D Powell <Mark.Po  2008-07-03 09:14:58 
Re: The light dawns - public synonym called SYS - how to drop?
Palooka <nobody@[EMAIL  2008-07-03 23:19:51 
Re: The light dawns - public synonym called SYS - how to drop?
gazzag <gareth@[EMAIL   2008-07-03 09:21:34 
Re: The light dawns - public synonym called SYS - how to drop?
"Terry Dykstra"  2008-07-03 18:11:03 
Re: The light dawns - public synonym called SYS - how to drop?
"phil_herring@[EMAIL  2008-07-03 16:37:08 
Re: The light dawns - public synonym called SYS - how to drop?
"Vladimir M. Zakhary  2008-07-04 12:28:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 7 1:04:21 CDT 2008.