Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to add column to a snapshot in Oracle7?
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
![]() |
![]() |