Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to add column to a snapshot in Oracle7?

How to add column to a snapshot in Oracle7?

From: Kai Regi <kai_at_rs.ee>
Date: 2000/05/06
Message-ID: <3914155C.AAA45ED8@rs.ee>#1/1

Hello all,
here is my case:

I have one big snapshot master table (about 1 million records) and several fast refresh snapshots in remote databases, all referencing the same master table. All databases are Oracle 7.3. I want add an (initially empty) column to master table and snapshots without recreating all snapshots.
Recreating is almost impossible due to slow and inreliable network, I simply do not have long enough continuous network time. I know, there is no such possibility in docs. Any dirty solutions? I have already tried some modifications in system tables, but they did not work, my new column did not start refreshing when I updated it in master site.
Thanks for any advise.

Kai Received on Sat May 06 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US