Re: Help! Consistent=y isn't working!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 31 Aug 2000 08:02:19 +0100
Message-ID: <967706031.13868.0.nnrp-08.9e984b29@news.demon.co.uk>

That sounds like bad news.
Is that 8.1.6.0 or 8.1.6.2 ?
Was the export a FULL=y export or a USER={list} export ?

What method did you use to check the time of transactions relative to the time that the export started ?

Were there any errors of any kind reported in the import log ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

NetComrade wrote in message <37caf8ce.5904860_at_news.earthlink.net>...


>I have exported and imported a database from one server to the other.

>After the import the application accessing was giving problems

>It turned out the sequences were screwed up, they seemed to be off by

>a fairly low #.

>So I checked the the exp started, 21:40:40pm, but the transactions

>that occured after the exp started, were still recorded in the exp

>file (up to 21:45). but my guess is the sequences actually stayed

>'consistent'.

>Is this a bug?

>

>oracle 8.1.6, solaris 2.7

Received on Thu Aug 31 2000 - 02:02:19 CDT