Re: ALTER SYNONYM?

[EMAIL PROTECTED] 06/30/01 04:56PM Is there a way to do what would be an ALTER SYNONYM? I've got a synonym created that rotates between pointing to two different tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is so that behind the scenes, I can truncate and reload

RE: ALTER SYNONYM?

a thought ... HTH, Remco -Oorspronkelijk bericht- Van: Rick Osterberg [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 5 juli 2001 18:06 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: ALTER SYNONYM? Well, here's what I'm trying to do. I've got a pile of tables that are read

RE: ALTER SYNONYM?

there's always a table available. Just a thought ... HTH, Remco -Oorspronkelijk bericht- Van: Rick Osterberg [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 5 juli 2001 18:06 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: ALTER SYNONYM? Well, here's what I'm trying to do. I've

Re: ALTER SYNONYM?

selected. SVRMGR Maybe some unwanted overhead with the view, but it might help out. Jim [EMAIL PROTECTED] 06/30/01 04:56PM Is there a way to do what would be an ALTER SYNONYM? I've got a synonym created that rotates between pointing to two different tables. Sometimes

RE: ALTER SYNONYM?

Although I have not used their software, I recall that Platinum's Desktop DBA has a feature for 'alter synonym. -Original Message- Sent: Sunday, July 01, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Rick: No. There is no alter synonym command in SQL (none that I can find

Re: ALTER SYNONYM?

PROTECTED] 06/30/01 04:56PM Is there a way to do what would be an ALTER SYNONYM?I've got a synonym created that rotates between pointing to two differenttables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This isso that behind the scenes, I can truncate and reload TABLE_A

Re: ALTER SYNONYM?

] Sent by: cc: root@fatcity.Subject: Re: ALTER SYNONYM? com

Re: ALTER SYNONYM?

Rick: No. There is no alter synonym command in SQL (none that I can find or know of, at least). The way you describe is the only way to do it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

ALTER SYNONYM?

Is there a way to do what would be an ALTER SYNONYM? I've got a synonym created that rotates between pointing to two different tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is so that behind the scenes, I can truncate and reload TABLE_A, and then swap, etc. so the table