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: Export hangs on last table in tablespace

Re: Export hangs on last table in tablespace

From: <fitzjarrell_at_cox.net>
Date: 14 Mar 2007 14:12:12 -0700
Message-ID: <1173906732.572757.29090@y66g2000hsf.googlegroups.com>


On Mar 14, 3:59 pm, "eAddict" <eAdd..._at_gmail.com> wrote:
> On Mar 14, 3:44 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > On Mar 14, 2:50 pm, "eAddict" <eAdd..._at_gmail.com> wrote:
>
> > Is the data exactly the same between these three servers? My guess is
> > that it isn't, and thereing may lie the source of your problem.
>
> Yes, the data is different BUT looking at the tail of the last export
> file the layout
> is the same. There is NO growth in the dump file, NO disk action,
> just the
> process consuming CPU.

You're not understanding this, are you? I'd be checking your source data in that 'last table' on the problem server against the data in that same table on the other two servers to see what, if anything, might be causing Oracle issues.

A 'tail -f' of the export log won't tell you anything more than you've already reported.

David Fitzjarrell Received on Wed Mar 14 2007 - 16:12:12 CDT

Original text of this message

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