[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
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
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
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
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
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
]
Sent by: cc:
root@fatcity.Subject: Re: ALTER SYNONYM?
com
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
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