Jeff,
Sorry, I didn't read your original email properly
(geez, I hate it when I do that) and now I see that
you're getting this error on creating the snapshot,
not refreshing it, so my previous answer won't help
you much.
What versions are the db's involved? If the master
site is not 8.0.6 or 8
Jeff,
This sounds like bug 893259 "CREATE SNAPSHOT ON TABLE
W/ VARCHAR2(4000) TRUNCATES COLUMN TO VARCHAR2(2000)"
that's fixed in 8.1.6 and later.
The bug causes the snapshot to be incorrectly created
with a varchar2(2000) column instead of the larger
column from the base table.
Have you comp
Patch your database with the appropriate bug fix.
--S
Jeff Wiegard wrote:
>
> Good Day.
>
> I have a problem with recreating some snapshots. I would like to
> add to the current set of snapshots. They were created in the
> following manner:
>
> create snapshot snap_test as select * from test
Good Day.
I have a problem with recreating some snapshots. I would like to
add to the current set of snapshots. They were created in the
following manner:
create snapshot snap_test as select * from test@test_DB;
They are executed nightly in the following manner:
execute DBMS_SNAPSHOT.REFRESH('