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 -> Re: Help! Consistent=y isn't working!

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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Sun, 03 Sep 2000 19:03:57 GMT
Message-ID: <37d01c0c.49684532@news.earthlink.net>

8.1.6.0
full=y
no errors :)
My scripts write to logs start of exp and end of exp Transaction times are entered by DEFAULT SYSDATE.

It's not that big of a deal, but I had a feeling that they should be exported properly.
When db is down, sequences get exported correctly.

On Thu, 31 Aug 2000 08:02:19 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>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 Sun Sep 03 2000 - 14:03:57 CDT

Original text of this message

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