Rick Osterberg wrote:
>
> Well, here's what I'm trying to do. I've got a pile of tables that are
> read-only tables that are downloaded periodically (approximately daily)
> from another system. They get slurped into our database via sqlloader.
>
> A previous incarnation of this process had the
. That way 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'
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 got
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data ta
PROTECTED]
Sent by: cc:
root@fatcity.Subject: Re: "ALTER SYNONYM"?
Can you use a view
instead?
SVRMGR> create table temp1 (temp1 varchar2(1));Statement
processed.
SVRMGR> create table temp2 (temp1 varchar2(1));Statement
processed.
SVRMGR> insert into temp1 values ('a');1 row
processed.SVRMGR> insert into temp1 values ('a');1 row
processed.SVRMGR> insert
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
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