Snapshot Problems

From: Jeff Wiegard <JWIEGARD_at_ngwmail.des.state.mn.us>
Date: Thu, 29 Nov 2001 10:02:03 -0800
Message-ID: <F001.003D0A6F.20011129083523@fatcity.com>

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_at_test_DB;

They are executed nightly in the following manner:

execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?');

However, when I try and create them, I get an ORA-01406 error, due to truncation of the varchar2(4000) . According to Oracle, this is a bug. Does someone know of a work-around?

Jeff

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jeff Wiegard
  INET: JWIEGARD_at_ngwmail.des.state.mn.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 29 2001 - 12:02:03 CST