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
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
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
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
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 into
]
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